PDA

View Full Version : [SOLVED] Macro to copy from Merged Cells (Same Range) to Columns of a New Worksheet



2977cc
11-07-2015, 08:04 AM
Good day everyone,
I've been collecting macros for my daily tasks but I haven't found one for this. Attached is the sample. Is possible to copy the description and the drawing nos. from merged cells in each numbered sheets, create a new sheet and paste on rows respectively. All i know is, this will loop thru the next 2 sheets and so on until the last sheet. Since I'm a self-taught dude, any help would be greatly appreciated.

p45cal
11-08-2015, 04:00 AM
cross posted and answered at ExcelForum