macro copy and paste criteria
rookie here - needs help
In worksheet 1 column "A" I have my subtotals I need to find subtotal "Jim" in column "A" of worksheet 1 xlToRight get subtotal amount copy and paste into a cell in worksheet 2 Note I need to this for each sales person's subtotal also note the cell reference will not be the same each week -- Randy |
macro copy and paste criteria
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Randy" wrote in message ... rookie here - needs help In worksheet 1 column "A" I have my subtotals I need to find subtotal "Jim" in column "A" of worksheet 1 xlToRight get subtotal amount copy and paste into a cell in worksheet 2 Note I need to this for each sales person's subtotal also note the cell reference will not be the same each week -- Randy |
All times are GMT +1. The time now is 11:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com