I have a group of stores which I need to input into Excel. I would like to format the input data on multiple sheets in different manners.
For example:
I receive reports with the following fields (each -- represents a different cell):
Store Name - Number - city - state - zip - owner - tel - fax - e-mail
John's Food - 12345 - lima - oh - 21445 - Smith, John - ## - ## - **
What I would like is, when I input the data on sheet 1, to have the data entered on other sheets in a different manner.
For example, on sheet 2 I might only want the store name and telephone.
On sheet 3, I might only want the person's name and e-mail, etc.
I would also like to figure out how a change made on sheet 1 would be able to effect a change on sheets 2 and 3, etc.
Any help would be greatly appreciated!!
Bookmarks