Hello MrExcel,
I am looking for help creating a Macros in Excel. Every year I have to update rates for the next year. I have about 1200+ rows of data and about 100 items. Each item has "Effective Dates" in column B starting from 1/1/2002, then 1/1/2003 all the way up to 1/1/2014 so every 12 rows or so the an item number ends with the effective date 1/1/2013.
What I need is to insert a row after each effective date of 1/1/2013 and copy the information in columns D:J down to the next row. Does this make sense?
In essence, I have
Carrier Effective Cancelled Item Subitem Carrier Item
XYZ 1/1/2011 1/1/2012 2 1532 9.24
XYZ 1/1/2012 1/1/2013 2 1532 9.24
XYZ 1/1/2013 / / 2 1532 9.24
I would like to run something that would search for 1/1/2013 in column "B" and insert a new row with the information in columns A, D, E, F, etc. like so:
Carrier Effective Cancelled Item Subitem Carrier Item
XYZ 2 1532 9.24
Please help.
Thanks!
I am looking for help creating a Macros in Excel. Every year I have to update rates for the next year. I have about 1200+ rows of data and about 100 items. Each item has "Effective Dates" in column B starting from 1/1/2002, then 1/1/2003 all the way up to 1/1/2014 so every 12 rows or so the an item number ends with the effective date 1/1/2013.
What I need is to insert a row after each effective date of 1/1/2013 and copy the information in columns D:J down to the next row. Does this make sense?
In essence, I have
Carrier Effective Cancelled Item Subitem Carrier Item
XYZ 1/1/2011 1/1/2012 2 1532 9.24
XYZ 1/1/2012 1/1/2013 2 1532 9.24
XYZ 1/1/2013 / / 2 1532 9.24
I would like to run something that would search for 1/1/2013 in column "B" and insert a new row with the information in columns A, D, E, F, etc. like so:
Carrier Effective Cancelled Item Subitem Carrier Item
XYZ 2 1532 9.24
Please help.
Thanks!