Avatar of Milind Agarwal
Milind Agarwal
Flag for United States of America asked on

Summarize data from worksheets into one worksheet.

Hi Everyone,
I have a workbook Lets say WorkbookA with multiple Tabs. I want to create a WorkbookB with a single tab.  Column A(WorkbookB) going to be the sr. no. Column B(WorkbookB) is coming from Column G of Workbook A. Column C(WorkbookB) is coming from Column D of WorkbookA. Column D(WorkbookB) is coming from Column F of workbookA. Column E(WorkbookB) is coming from Column E of WorkbookA and when the Column J of Workbook A has "Yes". Wondering if this can be achieved thru VB. Any help will be appreciated. Please find the attachment.
WorkbookA.xlsx
WorkbookB.xlsx
Microsoft ExcelVisual Basic ClassicVB ScriptSpreadsheets

Avatar of undefined
Last Comment
Milind Agarwal

8/22/2022 - Mon
Saurabh Singh Teotia

Quick question are you open to your workbook B template sheet present in Workbook A itself and once you run the macro it clears the old data and collates the new data in it and then you can do a move and copy .of the worksheet..create a copy and save it as a new workbook everytime..are you open to this idea??
Milind Agarwal

ASKER
Yeah that would work!
ASKER CERTIFIED SOLUTION
Saurabh Singh Teotia

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Milind Agarwal

ASKER
Thanks Saurabh really appreciate it.
Your help has saved me hundreds of hours of internet surfing.
fblack61