# Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.