i have a workbook with multiple sheets
i need a formulla to set some sells automaticly from other sheets when the codes meet any of the sheets
i have uploaded the workbook and explains and give a test to make things clear.
thanks a lot for helping
i have a workbook with multiple sheets
i need a formulla to set some sells automaticly from other sheets when the codes meet any of the sheets
i have uploaded the workbook and explains and give a test to make things clear.
thanks a lot for helping
Do you really need 4 separate worksheets, each with just one row of 5 cells used? It would be easier to put this in a simple table in the main (Data) sheet, as it would only need to be 3 columns wide and 5 rows deep, allowing for headings.
Or is there something else that you are not telling us?
Pete
Agree with Pete. The generally accepted method for data storage/capture is to have all data on 1 sheet, if possible. You then run your extracts based on that single table.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks