Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Hi,
I am new to writing macros...I have a few books but I can't seem to figure this on out. So, I have the following data: Date Fuel Price 7/1/06 $5.65 7/2/06 $7.00 7/3/06 $6.32 Basically, I need to insert 23 rows under each date (so that i have a total of 24 rows for each date). Then, I'd like to copy the contents of the cells above the insertion so that i have a fuel price for every hour of each date. Does that make sense? I thought this would be easy...and now I've wasted so much time, I could have done it manually a million times now! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to repeat a formula a set number of rows apart | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |