I need a macro that will CUT and paste an entire row from sheet1 (that has headers in row 2) that has ANY date in column G and paste it into the next available row in sheet2. I also need it to delete the source rows in sheet1 so the rows that remain (that do not have a date in column G) have no blank rows in between them. Thank you!
Please Login or Register to view this content.
Last edited by venkatpvc; 12-21-2013 at 09:13 AM.
Give Feedback and Click(*)
It gives me a runtime error 424 and says object required. When I go to debug, it highlights "lr = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row"
code works fine for me, may be its because, you have diffrent sheet names?
Please Login or Register to view this content.
Last edited by venkatpvc; 12-21-2013 at 09:31 AM.
That works perfect. Thank you sooooooo much!
glad i could help,
if your problem solved PLEASE MARK THREAD AS SOLVED.
PLEASE CLICK STAR BUTTON TO ADD MY REP.
THANK YOU,
where is the star button??
in the attachment see the yellow highlighted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks