macro to extract section to output tab
I need a macro that will run against either tab (pm or rm) and extract the Trade History section into an output tab as shown.
trade-macro-v2.1c.xlsm
trade-macro-v2.1c.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 can change it to do whatever you need.
ASKER
How would I get it to give only one output depending on which sheet it was run against?
* You would query the user for a sheet name (Inputbox
* You would assume that the activesheet.name is the sheet to be processed -- warning: you need to check to see that the activesheet.name is PM or RM.
* It shouldn't matter. Let the code create both outputs and delete the one you don't want.
* You would assume that the activesheet.name is the sheet to be processed -- warning: you need to check to see that the activesheet.name is PM or RM.
* It shouldn't matter. Let the code create both outputs and delete the one you don't want.
ASKER
Actually it really does matter for this. I was asked to break it down into small pieces so to simplify what I am asking, I will just start referring to a single tab. Here is the new question >>> https://www.experts-exchange.com/questions/26882640/Expand-macro.html
ASKER
I was only wanting it to run against one or the other though. I want to be 'able' to run against either sheet.