beegeeblueboy
New Member
- Joined
- Mar 25, 2010
- Messages
- 29
Have been trying to do this with macro recorder and then realised not possible.
Thank you
Julian
- With workbook open check if worksheet name 'Combined' and if not create it.
- With workbook open check if worksheet name 'Errors' and if not create it.
- Activate first worksheet. Read each row and if cell A = "Y" select row and copy to the first empty row into worksheet 'Combined' from column 'B' and insert source worksheet name from column 'A'. (This identifies the source worksheet name for each row)
- If value in source cell A <> 'Y' then repeat 3 but copy into workbook 'Errors'
- Loop until end of active worksheet and then activate next worksheet and repeat 3 and 4
- When last worksheet has been processed close workbook invoking Save dialogue
Thank you
Julian
Last edited: