Code or something else to extract data

[Kim B]

Hello again. I need a code that extracts the data from G3 and J3 from all tabs labeled "by Store Data Pull x-xx". G3 represent forecast and J3 represents actual counts. The data will be used to in a pivot table to compare Forecast to Actual by day which is represented by the "by Store Data Pull x-xx". There may be another way to accomplish this task other than a code, so all suggestions are welcome. Each day of the month has its own tab "by Store Data Pull x-xx" tab.

The end result will land in a worksheet called Pivot data where Column A = Forecast and Column B will = Actual

Thank you

 

[dermie_72]

have you looked at this thread and then adapted it to your needs?

VBA to loop through worksheets

I am trying to write a macro to look at cell A2 in each sheet in a workbook, and if there is no data in this cell then to delete the worksheet. (so I am left with only the sheets with comprehensive data on). I am looking at cell A2 not A1 as there is likely to be residual date in row 1. The...

www.mrexcel.com

 

[Kim B]

Hello again. I need a code that extracts the data from G3 and J3 from all tabs labeled "by Store Data Pull x-xx". G3 represent forecast and J3 represents actual counts. The data will be used to in a pivot table to compare Forecast to Actual by day which is represented by the "by Store Data Pull x-xx". There may be another way to accomplish this task other than a code, so all suggestions are welcome. Each day of the month has its own tab "by Store Data Pull x-xx" tab.


View attachment 108803

The end result will land in a worksheet called Pivot data where Column A = Forecast and Column B will = Actual

View attachment 108804

Thank you

I took a look at the code you suggested but unfortunately, I am not adverse in writing code. I need the result to populate on a worksheet labeled Pivot Data and I only need the macro to look at those sheets labeled "by Store Data Pull x-xx tabs. There are quite few tabs in this workbook so to narrow down only those sheets that I need the data from would help the macro work better.