Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Collate info within workbook

  Asked By: Charlie    Date: Feb 08    Category: MS Office    Views: 839
  

I have a problem that I'm not sure CAN be solved. I'll try to
describe it as best I can.

We have a four sheet workbook, all with the same column headings. The
first three are used by three different sales managers to record each
vehicle they sell and the details of the sale. The fourth sheet is
the problem. We want Excel to automatically collate the information
from those other three sheets - not a summary or total, but actually
a complete list of the sales from all three sales departments.

I hope that makes sense! Can it be done? I have NO idea about VBA, so
if that is involved in the solution, I will probably need to be
walked through.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Collate info within workbook Or get search suggestion and latest updates.




Tagged: