INserting Specific Number of Rows via macro
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!
|