Hello all,
I am a beginner when it comes to VBAs, but hoping you all can help me solve this issue I am having. Essentially I have a workbook setup with multiple sheets. One of these sheets "Helper Tab" display all the information I need, but I need to consolidate it all one step further.
I am looking to stack "like" data on-top of each other (i.e A-G, H-N, O-U, and W-AB, whereas A is the same as H, etc.). Here is an example of the "Helper Tab" sheet.
I'd like this data to go into another sheet titled "Output" with a command button that loads the data when I click it (i need it to delete what ever info is currently there when I click it). In my below example I show the data starting on B7, but thats not mission critical. A couple other call outs, the data in the "Helper Tab" sheet is gathered via formulas, so it needs to display the result of the formula (not the formula its self) and it needs to be able to skip blank cells (may have a formula, but will not have any data). Column length may differ slightly, AND may change from week to week (though no column will be expected to go past 1k).
Example of the "Output" sheet.
Thanks in advance for assistance!
I am a beginner when it comes to VBAs, but hoping you all can help me solve this issue I am having. Essentially I have a workbook setup with multiple sheets. One of these sheets "Helper Tab" display all the information I need, but I need to consolidate it all one step further.
I am looking to stack "like" data on-top of each other (i.e A-G, H-N, O-U, and W-AB, whereas A is the same as H, etc.). Here is an example of the "Helper Tab" sheet.
I'd like this data to go into another sheet titled "Output" with a command button that loads the data when I click it (i need it to delete what ever info is currently there when I click it). In my below example I show the data starting on B7, but thats not mission critical. A couple other call outs, the data in the "Helper Tab" sheet is gathered via formulas, so it needs to display the result of the formula (not the formula its self) and it needs to be able to skip blank cells (may have a formula, but will not have any data). Column length may differ slightly, AND may change from week to week (though no column will be expected to go past 1k).
Example of the "Output" sheet.
Thanks in advance for assistance!