tigershark45_can's blog
IF VALUE EQUALS X THEN COPY PASTE ROW TO NEW SHEET
Submitted by tigershark45_can on 3 May, 2011 - 15:30Help!.. I would like to know how to copy paste from one sheet to another within the same file using the IF function.
Basically, looking a thousands of columns, if I want to copy specific rows (A15:K15), (B15:K15) etc.. of "sheet 1" to "sheet 2" only if (employee number) D15 = 11 (of sheet 1).
I would like the rows to follow in "sheet 2" and not appear at row 1500 if there is only 20 rows that were copied.
Does this make any sense? If VBA is needed... what would the code look like?
Thanks,
Tigershark
»
- 4 comments
- 46777 reads

Recent comments
6 years 4 weeks ago
6 years 42 weeks ago
7 years 2 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 11 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago