I am trying to populate blank cells in my spreadsheet with value
from another column. For example I have a column J with some blan
fields in it. I am looking for a formula I could use to populate thes
fields with the corresponding column value in DQ.
Any help with this will be greatly appreciated.
Message posted from http://www.ExcelForum.com
Select column J. Then Edit / Go To / Special / Blanks
This will select all blank cells in the column, with the first one
highlighted. Type = and then enter the corresponding reference in DQ. You
can then hit Ctrl Enter to populate all...Analyse with Excel
In Access 2000 when I used the Analyse with Excel button to export a report,
text fields are truncated (to 170 characters). How can i get round this
On Wed, 30 Jan 2008 07:51:03 -0800, MuJay
Have you tried:
>In Access 2000 when I used the Analyse with Excel button to export a report,
>text fields are truncated (to 170 characters). How can i get round this
...Illustrator to Excel
I have got some floor plan layouts which created in AutoCAD. Since it is
allowed to export as EPS / AI, as I am not familiar with AutoCAD, then I do
some updating and saved as AI format. The floor plan are boxes and lines just
like we can do in Excel. However, I can't copy them to Excel as Excel
creation but it comes out as a graphic. Are there any way copy and paste as
Excel Drawing? Or, I have to draw all boxes and lines in Excel again if I
=?Utf-8?B?aGFuYXdha3Vu?= <email@example.com> wrote in
news:B16CB61A-2721-468F-9355-77B8ED821B2E@microsoft.com...Updating Header / Footnote in Excel 2007
Our company has a Spread Sheet with multiple Sheets (Tabs). Some of the
Sheets are Portrait and some are landscape. Sheet one is a data input sheet
(Tab name is = Input Sheet). Any Data that is used multiple times throughout
the Spread Sheet is Input here. That part was easy, but getting the
Header/Footnote to update on all sheets without changing the page formatting
We are trying to get the following for the Header:
Town: Cell #: D5 TEO No: Cell #: D34
Page 1 of ?
Office: Cell #: D38 Supplier Order No: Ce...print an excel document from a computer without excel
Is there a way to print a excel document from a computer that does not have excel
Can I use print to file? If so, how do I print the file?
Download the Excel Viewer here:
"Francine" <firstname.lastname@example.org> wrote in message
> Is there a way to print a excel document from a computer that does not
> Can I use print to file? If so, how do I print the file?
...Excel Macros will not run
I have Excel 2002, when opening & trying to record a
Macro, it will not record at all. I have set my security
level to medium & ran a detect/repair. Still no results.
What do you mean by "will not record". Does the Record Macro dialog box come up? Does the Stop Recording toolbar come up. Did you check in the Visual Basic Editor to see if a Module is being created
Please provide some more details
----- Theresa wrote: ----
I have Excel 2002, when opening & trying ...sav excel doc in various folders one click
How to save an excel doc in several folders with one click?
You can use SaveCopyAs, see the Excel help for more information.
Regards Ron de Bruin
"geo" <email@example.com> wrote in message news:E1CFF1AA-D7FD-4F61-88B5-BE349DB1EAA1@microsoft.com...
> How to save an excel doc in several folders with one click?
...Excel Programming in VB
I want to program Excel in VB to open an existing Excel file and edit some
custom cells so new updated data for those cells are entered.
Can some help me with some suggestions or codes?
I think I'd start by recording a macro when I did it manually in Excel.
Then the next question: Do you really mean VB or VBA?
ms newsgrp wrote:
> I want to program Excel in VB to open an existing Excel file and edit some
> custom cells so new updated data for those cells are entered.
> Can some help me with some suggestions or codes?
...MS Excel 2003 automating new worksheet & transfer balances
Hi, Im a fairly basic Excel user and need help from the experts! I
have just converted a manual daily cash sheet form to an excel
spreadsheet. I want/need to automatically generate each new days cash
sheet and have it transfer the balances (bank balance & cash on hand)
from the previous day. At this time we are copying the original cash
sheet template to be used for the current days receipts and manually
entering those running balances from the previous day. Is there a
way to automate this process so the balances are transferred when each
new worksheet is created?
...A user says he can't get my drop down list to work in Excel.
I have a spreadsheet (Office 2003) where the first three columns are
controlled by drop down menus. Everyone else can click on the boxes and see
the drop down choices but one user says that when he left-clicks nothing
shows up. He also says that the right click only works on the two drop downs
next to the first one. So for those he can use the 'Pick from List' feature.
I don't understand why he is unable to see the dowp-down lists and only
right click on two of the three boxes. Is there some error with older
versions of Excel? Is there some secret checkbox on an Option...Excel: Combo Box
In Excel, I want a combo box, which can control on each cell.
How can I do that?
Because after I create the combo box, then cell link is B1, then the
combo box only control B1 value, I want it control all cell like this:
How do I fix that? Thanks.
accessman2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27953
View this thread: http://www.excelforum.com/showthread.php?threadid=474566
in another cell i use ind...how can I add hours in Excel?
I am trying to add payroll hours using excel. I know there is a really easy
solution to this but this is what I'm doing.
My formula to get total per day is =(A2-A1)+(A4-A3)
This formula IS giving me the right hours added, but when I add the totals
per day to get a total for payroll (2 weeks) I am getting some extremely off
number. My formula for that is just =SUM(C8+C13+C18+C23......)
Can anyone help me out?? I know I might need to format my totals so that it
adds hours and not time.
make sure that you format the total...CHAR(10) does not create new line in excel 2007
I am copying contents from multiple cells into one cell, I would like a new
line for each cell content being copied. I use the following forumula and do
not see a new line being created. I found this on microsofts site; however,
it does not work in Excel 2007... HELP!!
Where is your formula?
Anyway try this.
Copy the below formula and paste it in any the cell
Then copy that cell and do right click and select paste special and select
values and give ok. Now ...cannot access online help in excel
online help works in all office 2003 programs except excel
...Formula Help 06-02-10
I need a formula (will be in L2) to do the following--
IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
H2 separated by commas.
If G2 does not contain the text "bail" then I want L2 to remain blank.
Any help would be appreciated. Thanks! Heather
"HeatherJ" <HeatherJ@discussions.microsoft.com> wrote in message
>I need a formula (wil...how to copy Excel file on to a web site?
Excel will not allow Select All in Edit to copy the file so it can be put on
a web site so how can it be done?
It's difficult to understand what your trying to do, but in versions after
2000 you can go to File>Save as web page
Microsoft MVP - Excel
"drace19" <firstname.lastname@example.org> wrote in message
> Excel will not allow Select All in Edit to copy the file so it can be put
> a web ...windows 7 newsgroup? 01-27-10
Is there a Windows 7 newsgroup?
__________ Information from ESET Smart Security, version of virus signature database 4808 (20100126) __________
The message was checked by ESET Smart Security.
On Tue, 26 Jan 2010 21:40:51 -0700, *BUSY* wrote:
> Is there a Windows 7 newsgroup?
> __________ Information from ESET Smart Security, version of virus
> signature database 4808 (20100126) __________
> The message was checked by ESET Smart Security.
"*BUSY*" <krem...Workbook Crashes Excel
I am in the process of learning how to apply what I know about Visual Basic to
VBA in Excel. When I attempt to open a particular Workbook I get an error
message that says Excel "..has performed an illegal operation and will be shut
Under Details I find:
EXCEL caused an invalid page fault in
module VBE6.DLL at 01a7:65004f34.
Some of the VBA Code is set to run when I open the Workbook.
1. Is there some way to Disable the Code when I open a Workbook so I can look
for the problem?
2. I have a Hex Editor and a backup of said file. Is there anything I can
modify so the file ...DDE very slow with Excel 2002 repost
I have a DDE server app that my clients use to import data
into Excel. After some of my clients upgraded to Excel
2002 & Windows XP I received numerous complaints about
sevier performans deterioration. For example a spreadsheet
with 150 DDE links used to update for 2-3 min with Excel
200 on Windows 2000. With Excel 2002 on Windows XP it take
15 to 20 min for the same spreadsheet !!! As they spent
lots of money for the upgrade, everithing was blamed on my
DDE server. I took some of their documents and made some
test with different versions of Windows, Excel and
OpenOffice 1.1. I o...would like to open .LCD (lucid 3d) extensions in excel
have .lcd worksheets that i would like to convert to excel
...Business Portal (with GP 10)
If an Approver is out of office and already created requisitions are stranded
in the Approval Hierarchy, is it possible to add to the list of User
Permissions to extend approval permissions by Select Final Approval for Self,
allowing approver to self approve his/her on requisition created prior to
this new permission??
If not, how do we rescue stranded requisition in Appover's absence?
...Hard to explain
Okay - this is really tough for me to explain but I have a code for my
macro that I have an error on and I CANNOT figure out why! I am not
too good at explaining this so please ask any questions on info you
may need!!! Thank you so much in advance!!! Here is my code - please
please help me!
' Macro2 Macro
' Macro recorded 5/2/2006 by Authorized User
' Keyboard Shortcut: Ctrl+z
Sheets("Corp").Visible = True
...Cell formatting problem, Excel 97
I am encountering a problem with Excel 97 which is being used by th
executive vice-president of our company, and I would appreciate an
guidance in solving this problem.
She is inputting data into a worksheet she created by typing it in
"NN/NN" format, and would like to see it appear like this. Certai
cells she types into display the data correctly. However, other cell
automatically re-format the text into some variation of a date format
If you click on "Tools" and select "Format cells" and change th
formatting, it is not a permanent change; if you type any new d...Excel Problem
Last night Excel started messing up on my computer. Dell Computer
about 6 years old. Windows XP Pro, MS Office 2002. Open a
spreadsheet, Excel opens to a blank spreadsheet and then says it has
encountered an error and shuts down. Error appears to be something
about a kernel 32.dll (not sure). Tried detect and repair, safe
mode, nothing works. Does it from a file open, shortcut or program
launch. Need some advice.
Google is your friend
Don ...Why are the Edit, Insert and Format menus greyed out in Excel?
Lately, when I open any files in Excel, the Edit, Insert and Format menus are
always grayed out. I am unable to access these functions in my Excel files.
For your information, this happens when I open any file in Excel.
How do I restore Excel back to its original condition?
It's possible to switch the menus off in VBA, maybe you have run a workbook
that has done that as part of a protection routine, and it hasn'r re-enabled
them after exiting.
You may have also saved your standard Excel template with the code to do
this, so that's why it happens everytime.
write some VBA c...