March 8, 2021
I have a question. I got a new role to run a report every week and the previous employee didn't create a table for Data Source. She used Range and I like to create tables.
She also used the first 2 Columns with all sorts of formulas with over 50 columns from the Excel File. Do you think that it is a good idea to join formulas with the Excel report which is pulled from the company system? And then she created the Pivot Table. Now every week, I run that report and paste that raw data into that report in the Data Source Tab and refresh that Pivot Table, and send it to Management.
Should I create a table and paste it in Data Source every time or I should just paste one table for the first time and from next week onwards, I just paste that plain raw data? and it will automatically be converted into a table or I will have to convert the range into a table every single time. How would you advise me?
I won't be able to show you the sample but I think that I am pretty clear.
Thank you for your help.
1 Guest(s)