| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prefill column
Below is a sample of the data I download to a spreadsheet. I need to write a
macro to fill in the empty cells in column A with the data from the previous cell in the column with data. I know I didn't explain that well but in the example below, I need TF48 to fill in Col A for rows 3,4 & 5. Then T16A would fill in row 7 and T505 in row 9 and 10. I hope I've explained this sufficiently. Thanks in advance for your help. 1 A B C D 2 TF48 $100.00 ABC 20091116 3 $ 50.00 DTR 20091116 4 $ 25.00 PLO 20091116 5 $ 75.00 FRD 20091116 6 T16A $100.35 UYE 20091116 7 $124.55 PLE 20091116 8 T505 $109.00 REW 20091115 9 $876.90 JLO 20091113 10 $234.90 REW 20091116 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell validation prefill | Excel Discussion (Misc queries) | |||
| Prefill a text box on a form | Excel Programming | |||
| How can I prefill a text field with leading 0s? | Excel Worksheet Functions | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Threaded Mode
