create a macro
I have a large spreadsheet with about 25 columns, I want to pull information
from this sheet to individual sheets within the same workbook. IE I have a sheet labelled sales and I want to pull all the sales to a separate sheet for sales persson a & b but not c. Lets say all the sales (a,b,c) are in column b. Trinab |
create a macro
Don't use separate sheets. BAD idea in general. Instead, you could
1) simply apply data filters, then choose the sales person of interest from the dropo down. Use SUBTOTAL functions to perform calculations with the data that remains. OR 2) use a pivot table, with sales person as the row field, and other fields as data or column fields. HTH, Bernie MS Excel MVP "trinab" wrote in message ... I have a large spreadsheet with about 25 columns, I want to pull information from this sheet to individual sheets within the same workbook. IE I have a sheet labelled sales and I want to pull all the sales to a separate sheet for sales persson a & b but not c. Lets say all the sales (a,b,c) are in column b. Trinab |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com