Pull data within the work sheet and save as master sheet with pulled sheet name.

[amar.kshirsagar]

Hi All,

Require your help again.

I want to pull data within the worksheet and save as new sheet in a same i.e. master sheet.

Scenario -

Excel having 4 sheets, with same column, but row count will be different in sheet1 it will 400 rows, sheet2 may be 1000 rows, and so on.

I want pull all 4 sheets data to new one. Starts pull from column "A" and paste in master sheet from "B" and so on.

In a column "A" for each row require sheet name. From where data is pulled

I think I explained very well, but still I am attaching sample file which was done manually for your reference.

Regret for inconvenience if not explained well, so please go through attached file.

Regards

Amar K

[rollis13]

Cross-post: Pull data within the work sheet and save as master sheet. (http://www.excelforum.com/excel-programming-vba-macros/958189-pull-data-within-the-work-sheet-and-save-as-master-sheet.html)

[amar.kshirsagar]

HI ROLLIS,

Yes I post this thread, and don’t know about this type of cross posting is not allowed.

Tell me the action requires. I will follow.

Regards

Amar K