For the same spreadsheet, I want to create a different worksheet within the book for each product. Basically I want it to pull all numbers for product A,B,C, & D onto separate worksheets for isolated reports. Any ideas?
Thanks in advance!
For the same spreadsheet, I want to create a different worksheet within the book for each product. Basically I want it to pull all numbers for product A,B,C, & D onto separate worksheets for isolated reports. Any ideas?
Thanks in advance!
Last edited by jfs; 04-06-2011 at 09:20 AM.
In E2 of your sample place this formula:
=IF(C2<>"",C2,E1)
and drag it down
Then copy that range and paste special - values in the C column. Then delete E col.
This was my original formula! I see now though that I was using the worng data for the flase condition, thanks so much!
You answered so quickly as I was editing to add another question ...
Sorry, what values for the product do you want to get? A total number for the product or monthly values for the product? Will the month be placed on the separate sheet?
I want it to pull all monthly data; I already know the formula to total from there but I basically need the initial table broken down into separate sheets. I have edited the attachment to show what I would like the workbook to look like in the end. Thanks.
Here is your amended sample
Is your first worksheet ("Mock") where you will collect data or is this a one-time layout? If you are collecting data on an on-going basis, you would save yourself some time and trouble by filling the first column with the product name and making the id field a lookup.
The other benefit of keeping your data as a list is that you can then use a pivot table to summarize your information. By moving your products onto separate sheets, you are 1) missing out on some analysis opportunities and 2) increasing the work you have to do (creating and validating formulas on separate sheets, for example). Every time you move or manipulate your raw data, you create another opportunity for error.
Just a thought.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks