Hi all,
I have been trying to work this out for about 2 weeks reading the posts here and everywhere but I cant seem to get it to work at all. I need to create a VBA to move and copy rows twice based on a condition.
I have a large spreadsheet with columns A to W in it that is populated using formulas from another sheet
Sheet 1 = Input
Sheet 2 = The one I need to take from
Sheet 3 = Where I need it to go
In column J I have this formula:
=IFERROR(VLOOKUP(L5,Refernce Sheet!$H:$I,2,0),"")
I need to move all rows where there IS something in column J to Sheet 3 *TWICE* - It needs to paste as values to the next available row in Sheet 3 and then the same thing again in the row below it - ignore any rows that are blank in J on Sheet 2 and move on to check the next
Its very messy so there could be 3 rows with something then 5 without then 2 with and 7 without etc (goes down to about 12k rows)
It needs to paste as values and not as formulas in Sheet 3
Any help would be massively appreciated as a newbie I'm all in a buzz about this one
I have been trying to work this out for about 2 weeks reading the posts here and everywhere but I cant seem to get it to work at all. I need to create a VBA to move and copy rows twice based on a condition.
I have a large spreadsheet with columns A to W in it that is populated using formulas from another sheet
Sheet 1 = Input
Sheet 2 = The one I need to take from
Sheet 3 = Where I need it to go
In column J I have this formula:
=IFERROR(VLOOKUP(L5,Refernce Sheet!$H:$I,2,0),"")
I need to move all rows where there IS something in column J to Sheet 3 *TWICE* - It needs to paste as values to the next available row in Sheet 3 and then the same thing again in the row below it - ignore any rows that are blank in J on Sheet 2 and move on to check the next
Its very messy so there could be 3 rows with something then 5 without then 2 with and 7 without etc (goes down to about 12k rows)
It needs to paste as values and not as formulas in Sheet 3
Any help would be massively appreciated as a newbie I'm all in a buzz about this one