LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Insert Row Above and Calculate Difference Between Dates

I have a full worksheet of about 5,000 rows. I am looking for help so I can
insert a row above each row with contents starting in Row 2. Minus the date
in Column C for each row with contents from todays date and put the
difference in Column B the empty row above. Here is what I have now. If you
can help me, thank you.

Sub Insertrowcalculate()
Range("2:2,4:4,6:6,8:8,10:10").Select
Selection.Insert Shift:=xlDown
Range("4:4,7:7,10:10,13:13").Select
Selection.Insert Shift:=xlDown
End Sub

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate difference between 2 dates nikko Excel Worksheet Functions 16 September 11th 08 11:15 AM
Calculate difference in dates Geo Excel Discussion (Misc queries) 11 August 12th 08 07:18 AM
How do I calculate the difference between 2 dates (m,d,y) ? ady_sandu Excel Worksheet Functions 8 September 29th 05 05:09 PM
Calculate Difference b/e 2 dates. scharee New Users to Excel 2 August 2nd 05 04:28 PM
Calculate difference between two dates Trainer Excel Worksheet Functions 1 February 11th 05 02:04 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"