Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Copy Data to Cells, but Stop at Next Non-Empty Cell
I have a spreadsheet with the following data:
Column A Column B 05:00 Item A Item B Item C 07:00 Item A Item B 09:00 Item B Item C Each item corresponds with the time in the same block. What I want to accomplish is have the time move down until it comes to the next time. Shown below: 05:00 Item A 05:00 Item B 05:00 Item C 07:00 Item A 07:00 Item B 09:00 Item B 09:00 Item C So it copies the time down until it comes to the next, non-empty cell. What I'll then do is count the number of item a entries at specific times (morning vs afternoon) and so on. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop index match returning data where lookup cell empty | Excel Worksheet Functions | |||
Copy cell to empty cells below. | Excel Programming | |||
Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming |