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.