Need Help to Append data from different different tab of workbook to in another workbook

[Naveed Raza]

Hi All,

I need help to figure out the VBA Code.

I have one master file and this master file contain two tabs one is Setup tab and another one is Raw data tab and I have daily prod report file and this file contain month daily wise data by tab wise and with other tabs also.

what i am trying to do here is , i want to cumulate info from daily prod report file from different different tab and append in master file raw data tab ,
what ever i want means suppose daily prod report file contain 4 tabs like (1203,1204,1205,external) from this tab i just want to cumulate only (1203,1204,1205) for tab selection u can make userform or else in other way.

for tab selection i make a setup tab in master file , macro will first extract the tab names and in column B in master file i will manually key combine whatever the tab i want to combine.

please find the attached two workbooks and i hope my explanation make some sense for understanding.

any help more appreciate !

Thanks - Naveed.

[arlu1201]

So you want to combine data from the numerical tabs from your source files into the master file. This part is fine. Will there be many source files to copy to the master file?

Can you explain about the combination part?

[Naveed Raza]

s , once we run the macro , macro first select the tab that is 1203 and then copy data from b6 to last column cell to down and paste in master file raw data tab from b6 and then next macro select next tab and copy and append in master file raw data tab.

[arlu1201]

Yes i understood that part. Can you explain this - ?

for tab selection i make a setup tab in master file , macro will first extract the tab names and in column B in master file i will manually key combine whatever the tab i want to combine.

[Naveed Raza]

oh that one, in attached master file i wrote a code to get a tab names of another attached workbook and that all tab names will captured in master file setup tab in column B and in column C we need to entered Combine manually after that again we need to run a combine macro and this macro will do in beginning is it will paste a tab names in column E which we entered manually in Column B then next that macro will proceed to next step.

for better reference u can check my written code in attached master file

[arlu1201]

So for now you only want the consolidation right?

[Naveed Raza]

S consolidation of selected tabs only.

[Naveed Raza]

Hi,

Any update plzzzzz

[Naveed Raza]

Hi,

Sorry I know I am disturbing you but I just want to know is there any solution for my request.

[Naveed Raza]

Hi,

please may i know any update on this request.

[oeldere]

Maybe this can be an start.

Please reply if this is what you're up to.

Beneath you find the code

Please Login or Register  to view this content.

[Naveed Raza]

Hi Oeldere,

Thank you so much quick reply, its work perfectly.

but i don't want consolidate data in this same workbook, i need a separate macro file and that file u can find out in my 1st post , in that sheet one setup tab is thr and one more is raw data.

In setup tab i need all the tab names which is available in task to combine workbook bcz i dont want to consolidate other than external tab bcz its depends on the user and one more thing tab will increase day by day and i want to consolidate only whatever tab i need means suppose in that workbook total 4 tabs are thr (1203,1204,1205,1206) and from this 4 tab i want to consolidate only 2 tabs (1204,1206) by selecting a tab name.

for tab selection u can make userforms or else format in excel like a mention in master macro file workbook.

I hope my explanation is now clear and sense-able.

Thanks you so much sir for your help and plz sir if this possible plz make it happen

[oeldere]

I can't help you enough with your further question.

I should solved it with an pivot table.

See the attached file.

What does bcz means?

[Naveed Raza]

k , i will get back to u sir.

bcz means because

[Naveed Raza]

Hi oeldere Sir,

Sorry for late Reply , i will get time only on weekends that's why.

about my request, i want to explain from beginning sir please if possible resolve it and i am sure this will resolve here.

well, In my fast post i have attached two workbook (one is MACRO File and another one is Task to Combine sheet).
- workbook Macro File contain two TABS (one is SETUP tab and another one is RAW DATA Tab).
- workbook Task to Combine contain Daily Wise data in Date Wise along with External Tab.
-- In Task to combine workbook that TABS will Increase Day by Day.

What exactly i want here is ,
1) whatever the TABS Available in TASK TO COMBINE Workbook that All TABS Names should Shown in MACRO FILE workbook in Setup Tab (In Column B) and In Column C user will Manually Enter "Combine" for that Tab Name which one the User want to Cumulate.
2) Next Whatever the Combine status is there in Column C with respect to Column B that all Tab Data Should Cumulate in MACRO FIle in Raw Data Tab from Task to Combine workbook.

Like this I want Sir.

I hope now my Explanation is more clear and I hope this will resolve now.

Thanks for all your assistance.

[oeldere]

As I already stated: I can't help you enough with your further question.


Have you looked at my file, and expecially the pivot table?

Please Login or Register  to view this content.

I think a pivot table can do that for you.