pg1533
asked on
Data consolidation
Hi,
I have workbook attached and is named as ‘DataDump’. It has the following worksheets
1. Sheet 1
2. Sheet 2
In ‘Sheet1’ workbook we have the name of the companies listed in column A. We are trying to get the total points received for each company for each month by comparing the data which is there in ‘Sheet2’.
I have used an array to get the data and it is perfectly working. I know that we can also use pivot to get this numbers from ‘Sheet2’. The only problem which I am facing is that it is literally making excel slow while calculating. I also know that while working on excel we can make the calculations to ‘Manual’ which would make excel to work faster. Is there is way where on click of a button all the calculations should be done (basically a macro to do this) and display the results as shown in the example attached. Please advise.
Regards,
Prashanth
DataDump.xlsx
I have workbook attached and is named as ‘DataDump’. It has the following worksheets
1. Sheet 1
2. Sheet 2
In ‘Sheet1’ workbook we have the name of the companies listed in column A. We are trying to get the total points received for each company for each month by comparing the data which is there in ‘Sheet2’.
I have used an array to get the data and it is perfectly working. I know that we can also use pivot to get this numbers from ‘Sheet2’. The only problem which I am facing is that it is literally making excel slow while calculating. I also know that while working on excel we can make the calculations to ‘Manual’ which would make excel to work faster. Is there is way where on click of a button all the calculations should be done (basically a macro to do this) and display the results as shown in the example attached. Please advise.
Regards,
Prashanth
DataDump.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER