LinkBack URL
About LinkBacks
I am attempting to cut and paste a row (cut and paste occurs on the same sheet {pic}) if a cell value within that row is ">=" a cell value on a different sheet.
I am attempting to cut and paste a row (cut and paste occurs on the same sheet {pic}) if a cell value within that row is ">=" a cell value on a different sheet.
Last edited by sinistr0311; 07-19-2013 at 12:43 AM.
Progress this leaves me with blank rows, tried it with selection.delete shift:=xlup first, but during my 1st debug I relized this would cause rows to be skipped. If 2 consecutive rows need to be moved, the second row would be skipped due to the shift xlup.
Also it runs very slow. When I tested it on a table with 400 rows, I could see the rows on the far left table being populated top to bottom, as opposed to "snap" and its done.
I got this idea from one of ExcelVBAIsFun videos about loops.
Please Login or Register to view this content.
no errors with this one so far. Been working on this little block all day. Finally, and with no direct assistance. The top portion is what I came up with so I am hoping their will be no issues. I understand how it is working. The filtering portion was taken from a google search. For the blanks I tried using a similar method I use to find the >= rows, but the same issue with skipping rows if their were 2 consecutive executions.Please Login or Register to view this content.
Last edited by sinistr0311; 07-19-2013 at 02:26 AM.
this is where I ended up
copy data from my daily sheets to a consolidation sheet, then cut/paste specific data based on cell value and get rid of the empty rows
Please Login or Register to view this content.Please Login or Register to view this content.
For the days I don't have data I normally delete the sheets. When I did I ran into a couple problems. Some of the code was not executing on the correct sheet. I wasn't able to use the tab name because it changes every month so I adjusted it with this.
and thisPlease Login or Register to view this content.
I hope this helps someone with similar circumstances.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks