Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filling Blank Cells
Hi
I run Excel 2K I have some information that I download from a mainframe into a spreadsheet. See Example Smith Training Module 1 Training Module 2 Training Module 3 Smith Training Module 4 Alder Training Module 1 Training Module 2 Alder Training Module 3 As you can see, the information that is duplicated leaves blank cells between the first and last entries of each unique record. I would like to have a macro or code or similar to be able to fill in these empty cells with the missing unique entries. Any suggestions? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filling Blank Cells
Debra Dalgleish shares a few techniques here (manual and macro):
http://contextures.com/xlDataEntry02.html and a video http://www.contextures.com/xlVideos01.html#FillBlanks John Calder wrote: Hi I run Excel 2K I have some information that I download from a mainframe into a spreadsheet. See Example Smith Training Module 1 Training Module 2 Training Module 3 Smith Training Module 4 Alder Training Module 1 Training Module 2 Alder Training Module 3 As you can see, the information that is duplicated leaves blank cells between the first and last entries of each unique record. I would like to have a macro or code or similar to be able to fill in these empty cells with the missing unique entries. Any suggestions? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling in blank cells with cell above | Excel Worksheet Functions | |||
problem filling in blank cells with data above - | Excel Discussion (Misc queries) | |||
Filling Blank Cells | Excel Worksheet Functions | |||
Filling Blank Cells | Excel Discussion (Misc queries) | |||
Filling in Blank Cells | New Users to Excel |