LinkBack URL
About LinkBacks
welshgirl89
you could try changingto
Set lastRng = ThisWorkbook.Sheets("Master Budget").Range("a33").End(xlUp).Offset(1, 0)the 2 adds another rowSet lastRng = ThisWorkbook.Sheets("Master Budget").Range("a33").End(xlUp).Offset(2, 0)
welshgirl89
you could try changingtoSet lastRng = ThisWorkbook.Sheets("Master Budget").Range("a33").End(xlUp).Offset(1, 0)the 2 adds another rowSet lastRng = ThisWorkbook.Sheets("Master Budget").Range("a33").End(xlUp).Offset(2, 0)
that just adds a new row inbetween the data of each project group. is there no way it can just add to the next free row in the master sheet?
also, is there a macro or a shortcut to run the code when just on the excel spreadsheet so once the new data can be added a button just needs to be pressed to automatically run it? tried creating a macro to do it but it didn't work.
thanks again!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks