I am supplied with a spreadsheet with 40+ tabs. At different times I want to a import different tabs based on a marker in against the tab name in a table.
Previously I have written a line of code for each tab as all records were required at once.I now need to import selected groups at different points in time, I would like to reference the table which holds the tab name and the week in which it is to be imported. Is there a way of stepping through the table and importing the records that have the correc marker.
Hope I have made myself clear, any suggestions will be graciously recieved. (as long as they don't end in off).
Kenny
Previously I have written a line of code for each tab as all records were required at once.I now need to import selected groups at different points in time, I would like to reference the table which holds the tab name and the week in which it is to be imported. Is there a way of stepping through the table and importing the records that have the correc marker.
Hope I have made myself clear, any suggestions will be graciously recieved. (as long as they don't end in off).
Kenny
