I'm trying to divide my file in 2.
One of then that contains the all data, the other one that calculates the results and that is shown to the user.
A few years ago, In Access, i did this same thing with no problem, with Excel i just cant do it.
The problem is that i want to update...
I know nothing about VBA/Macro, I'm looking to have multiple .csv files, filtered by column (B) value.
I have data in separate file organized as excel table range. I want to use this table name as a source for pivot table in other file. The funny thing it doesn't let me do this saying the range is wrong. Though it works ok inside 1 file.
Additionally, trying to come around, when I...
My workbook has two workseets that I need to split by an area and then save each new workbook under the areas name. Before anyone says combine the two sheets to make it easier we can't; we have to have 2 separate sheets for this particualr report
This is the file that contains all...
My manager would like me to create charts for 30+ departments every month in separate files with their average weekly spend for the past year and headcount.
There are sub-departments that I've been using in the page field of a pivot chart so the manager can view total spend, or spend by...