Transposed data...
Experts:
In a previous question (https://www.experts-exchange.com/questions/29105843/Need-VBA-to-transpose-data.html?anchor=a42604159¬ificationFollowed=209100880&anchorAnswerId=42604159#a42604159), expert Subodh Tiwari (Neeraj) has provided a superb solution which transposed data (via VBA) from "raw format" into a new desird format which would enable me to graph the data.
Please find attached the spreadsheet which includes three tabs:
1. "Raw Data"
2. "Transposed Data"
3. "Graph"
As of right now, the raw data tab includes sales information by category across dates. When clicking on the command button "Transpose Data", the tab "Transposed Data" is updated across three columns (categories, sales amount, and dates). For testing purposes, I recommend to delete the all data from the "transposed data" tab and re-run it via the command button on tab "raw data". You will see, based on Subodhs' VBA code, the data is transposed again and the whole process takes only about 1-2 seconds. Everything works great thus far.
Now, here comes the "graphing the data" part which resulted in a totally unexpected issue. Given the unanticipated problem, I added a space (" ") prior to the formulae in cells B5:B25. Anyhow, as you can see, the formulas reference the data from the "tranposed tab". Here's the problem now... if I remove the blank space from the formulas B5:B25, it appears that I can longer no run the "Transposed Data" command button any longer. Specifically, if I were to run the VBA again, Excel (i.e., VBA) keeps on spinning and spinning and ultimately, I am forced to shut down Excel via CTRL-ALT-DEL.
Again, to recap, the command button "Transpose Data" (on tab "Raw Data") when the formulas (on tab "Graph") are inactive (e.g., having a space).
My question: How can I modify the process (not VBA) so that I can continue to update/transpose the raw data without having to temporarily add the blank space before the formulas on the "Graph" tab so that the VBA can execute and transpose the raw data?
Thank you,
EEH
Transposed-Data.xlsm
In a previous question (https://www.experts-exchange.com/questions/29105843/Need-VBA-to-transpose-data.html?anchor=a42604159¬ificationFollowed=209100880&anchorAnswerId=42604159#a42604159), expert Subodh Tiwari (Neeraj) has provided a superb solution which transposed data (via VBA) from "raw format" into a new desird format which would enable me to graph the data.
Please find attached the spreadsheet which includes three tabs:
1. "Raw Data"
2. "Transposed Data"
3. "Graph"
As of right now, the raw data tab includes sales information by category across dates. When clicking on the command button "Transpose Data", the tab "Transposed Data" is updated across three columns (categories, sales amount, and dates). For testing purposes, I recommend to delete the all data from the "transposed data" tab and re-run it via the command button on tab "raw data". You will see, based on Subodhs' VBA code, the data is transposed again and the whole process takes only about 1-2 seconds. Everything works great thus far.
Now, here comes the "graphing the data" part which resulted in a totally unexpected issue. Given the unanticipated problem, I added a space (" ") prior to the formulae in cells B5:B25. Anyhow, as you can see, the formulas reference the data from the "tranposed tab". Here's the problem now... if I remove the blank space from the formulas B5:B25, it appears that I can longer no run the "Transposed Data" command button any longer. Specifically, if I were to run the VBA again, Excel (i.e., VBA) keeps on spinning and spinning and ultimately, I am forced to shut down Excel via CTRL-ALT-DEL.
Again, to recap, the command button "Transpose Data" (on tab "Raw Data") when the formulas (on tab "Graph") are inactive (e.g., having a space).
My question: How can I modify the process (not VBA) so that I can continue to update/transpose the raw data without having to temporarily add the blank space before the formulas on the "Graph" tab so that the VBA can execute and transpose the raw data?
Thank you,
EEH
Transposed-Data.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome!
ASKER
Thank you for your continued assistance... I very much appreciate it.
EEH