A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Basic file, data only once to summary?



 
 
Thread Tools Display Modes
  #1  
Old November 11th, 2009, 10:59 AM posted to microsoft.public.excel.misc
Needtoknow
external usenet poster
 
Posts: 55
Default Basic file, data only once to summary?

I have file, which has in Sheet1 about 300 rows including product number,
prod name, vendor number, vendor name etc. Same product number can be for ex
3 or 5 times because it can be bought from different vendors, as well as
vendor data is many times because many products are bought from same vendor.

Sheet1 has following columns:
A – prod number
C – prod name
J – vendor number
K – vendor name

Now I need to make summary for vendors to Sheet2 and for products to Sheet3.
Best result would be if same information is there only once and nothing has
to be done, so this automatically updates all files.

All updating has to be in Sheet1 and if deleting and adding rows to Sheet1
can be allowed, this would be the ultimate solution.

I have tried FIND, SEARCH and all but cannot find any real solution. So far
I have always (when data is needed) get it through Data – Filter - … - unique
only. But now I am bored to do this if there is easier way. Any help or
ideas…?
  #2  
Old November 11th, 2009, 11:53 AM posted to microsoft.public.excel.misc
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default Basic file, data only once to summary?

Use pivot table, since it's the easiest way of generating reports.

--------------------
(Ms-Exl-Learner)
--------------------



"NeedToKnow" wrote:

I have file, which has in Sheet1 about 300 rows including product number,
prod name, vendor number, vendor name etc. Same product number can be for ex
3 or 5 times because it can be bought from different vendors, as well as
vendor data is many times because many products are bought from same vendor.

Sheet1 has following columns:
A – prod number
C – prod name
J – vendor number
K – vendor name

Now I need to make summary for vendors to Sheet2 and for products to Sheet3.
Best result would be if same information is there only once and nothing has
to be done, so this automatically updates all files.

All updating has to be in Sheet1 and if deleting and adding rows to Sheet1
can be allowed, this would be the ultimate solution.

I have tried FIND, SEARCH and all but cannot find any real solution. So far
I have always (when data is needed) get it through Data – Filter - … - unique
only. But now I am bored to do this if there is easier way. Any help or
ideas…?

  #3  
Old November 11th, 2009, 01:16 PM posted to microsoft.public.excel.misc
Needtoknow
external usenet poster
 
Posts: 55
Default Basic file, data only once to summary?

That would be one possibility if I only use this file. But the idea is to
have this information for others to use just by copy'ing Sheet2 and Sheet3 so
they don't have to _do_ anything.

"Ms-Exl-Learner" kirjoitti:

Use pivot table, since it's the easiest way of generating reports.

--------------------
(Ms-Exl-Learner)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.