**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to automatically extract a sheet from muliple workbooks into a combined workbook with all sheets. Then I need a formula to add up each column from all the sheets

Solved by C. J. in 15 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
10/09/2018 - 12:19

ok

User
10/09/2018 - 12:19

its greyed out

Excelchat Expert
10/09/2018 - 12:19

Hekko

User
10/09/2018 - 12:20

you have team viewer?

Excelchat Expert
10/09/2018 - 12:20

Sorry for the typo... Hello

Excelchat Expert
10/09/2018 - 12:20

no we will need to work through the chat

User
10/09/2018 - 12:20

ok

User
10/09/2018 - 12:21

POS system - generates daily report of sales every day into excel workbook with two spreadsheets

Excelchat Expert
10/09/2018 - 12:21

Can you please elborate on the excel problem?

Excelchat Expert
10/09/2018 - 12:21

ok...

User
10/09/2018 - 12:21

so I will have approximately 30 sheets per month

User
10/09/2018 - 12:22

* sorry

User
10/09/2018 - 12:22

30 workbooks per month

User
10/09/2018 - 12:22

with 2 worksheets in each one

User
10/09/2018 - 12:22

I need to extract sales data from one column

User
10/09/2018 - 12:22

so I have combined total for the month of sales

User
10/09/2018 - 12:23

Maybe a lookupsum formula?

User
10/09/2018 - 12:23

or extract and combine the worksheets into a single excel book and run formula?

Excelchat Expert
10/09/2018 - 12:23

Can you share a sample workbook?

User
10/09/2018 - 12:24

[Uploaded an Excel file]

Excelchat Expert
10/09/2018 - 12:24

i belive the format of each workbook from the POS system is same..

User
10/09/2018 - 12:26

so each day creates one of those sheets

User
10/09/2018 - 12:26

I need to get monthly totals

Excelchat Expert
10/09/2018 - 12:28

Combining all the data and building a monthly total cannot be done via formula...

User
10/09/2018 - 12:28

macro?

Excelchat Expert
10/09/2018 - 12:28

we will need to build a macro for extracting the data into a common excel

User
10/09/2018 - 12:28

ok

Excelchat Expert
10/09/2018 - 12:29

and then build necessary formula..

Excelchat Expert
10/09/2018 - 12:29

are you familiar with macro?

User
10/09/2018 - 12:29

no

Excelchat Expert
10/09/2018 - 12:30

We do not support creating macro on this portal.. as this takes lot of time to have it built..

User
10/09/2018 - 12:30

who can build it?

User
10/09/2018 - 12:31

happy to pay if required just want to know how much first

Excelchat Expert
10/09/2018 - 12:32

On this portal.. we only support excel formula and graph.. problem..

Excelchat Expert
10/09/2018 - 12:32

i wouldnt be able to tell from where you could get this build..

Excelchat Expert
10/09/2018 - 12:34

Since this excel problem needs Macro based solution.. I have marked the session as DONE..

User
10/09/2018 - 12:34

ok

Excelchat Expert
10/09/2018 - 12:34

Please leave a feedback when you close the session

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*