Allocate data from one sheet to the respective fields in another sheet

sreejeshc

New member
Joined
Sep 28, 2012
Messages
2
Reaction score
0
Points
0
Hi guys,

I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate cells in other sheets based on m/c no:. Sample file is attached.
 

Attachments

  • test1 file.xlsx
    20.1 KB · Views: 22

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
I think I understand but just want to clarify a few points.

You input data on sheets cell1 and cell2, and want all the data to end up on the Data sheet to view it all together.
You have 2 forms on each of the cell sheets, will these remain a constant size, or will this need to grow past row 13?
You seem to have more data input on the cell sheets than you have on the data sheet, do you need all the information or just part of it from the cell sheets?
Will the Data sheet need to be cleared and refreshed each time you copy the data, or do you need a complete history on the data sheet?

Simi
 
Top