View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
[email protected] spiccioli@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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!