Summarize data from worksheets into one worksheet.
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