Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
I am using a PC and working on Excel 2003. I have a spreadsheet and have
random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
You say you want to copy the cell, but you don't say where you want it
pasted. Also, there are lots of blank cells around your actual data. What is the range of your data in which you want to do this? And what if the cell above an empty cell is also blank? HTH Otto "Oceangate" wrote in message ... I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
Type a formula in any of the unused cell. say(J2). The formula would be =J1.
Copy the cell (not the formula). Keeping your copy in clipboard. Select your data range. Press F5From Goto window select blanks. Click OK This should select all blanks.. Now, right clickPasteSpecialFormulas OK If this post helps click Yes --------------- Jacob Skaria "Oceangate" wrote: I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
See if this is what you had in mind:
http://contextures.com/xlVideos01.html#FillBlanks -- Biff Microsoft Excel MVP "Oceangate" wrote in message ... I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
Jabob, That worked perfectly, Thanks a lot......
Biff I'll check out your link "Jacob Skaria" wrote: Type a formula in any of the unused cell. say(J2). The formula would be =J1. Copy the cell (not the formula). Keeping your copy in clipboard. Select your data range. Press F5From Goto window select blanks. Click OK This should select all blanks.. Now, right clickPasteSpecialFormulas OK If this post helps click Yes --------------- Jacob Skaria "Oceangate" wrote: I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If blank cell, copy information from cell above
Hi,
Select the range and press Ctrl+G and then click on Special Blanks. Now all the blank cells will be selected and the first blank cell will be the active cell. Now type =, then the up arrow key and then Ctrl+Enter -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Oceangate" wrote in message ... I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information from the cell directly above it. This information could be a persons name, date or number. For example if my cursor is in cell A10: IF A10 is blank, copy A9, else, don't copy. How do I put this formula in the spreadsheet so that I can have the blank cells filled with the information from the cell above and at the same time not affect the information already there? Thanks in advance for your help. Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i copy information from a cell into a comment? | Excel Discussion (Misc queries) | |||
Vlookup information from blank cell | Excel Worksheet Functions | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Copy information from one cell to several different cells | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |