Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert new rows when date changes
I want to do it in A, B and C but I have other data in E through to K. I don't have formulas in this spreadsheet - it's a price list. The items are coded as to where they belong by code in A, B & C. I want to add blank lines with each change, copy the code up into the blank space, then using...- sallylou
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Insert new rows when date changes
I have just tried your macro to insert new rows as cell value changes. I have column A, B, and C all of which I want to add a new row to at a change of value. What do I have to do to the macro to make it work in columns B & C as well as A? Thanks - sorry new to Macro's. Sally- sallylou
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
