Duplicate data from on tab to a master tab

Hi TrowaD,

Thank you for commenting yes people will be filling in rows of data (1 at the time and below each other) what I'm trying to do is get a workbook that automatically updates as people input data on it, so that myself and others members of staff can see who is busy and what work is being done.

That's if I can get something like this to work.

Regards

Paul

If one delete a row from one of "non-master" sheets, what should happen to the row that was copied to master ?

if one edits a row in one of the "non-master" sheet, what should happen to that row in the master sheet

If objective of this master is to see whats happening in all other sheets without going sheet to sheet, one option that you may want to consider is have a macro, where you ask for copy all data from all sheet for a given time frame. Of course this all depends on what is the purpose and usage of Master

It seems to me that data is not deleted but is and can be edited, which throws a wrinkle that one has to examine if a new row was added or edited.

From what I understood, so far

1. Master sheet contain copied data from all sheets that are still in progress (not ready to be archived). The original sheets still has data.

2. Archive sheet contain moved data from all sheets that were completed (as indicated by a certain column that date). The original sheets will no longer have those rows

If that is the case, most safe way would be.
1 Have a macro to copy data from all sheets into Master
2. Have a macro to move data from all sheets into Archive

OR
3. Combine functionality #1 and functionality #2 into one macro

when you run functionality #1, it deleted previous master data and copies the new data

when you run functionality #2, it moves the data from sheets to archive by appending to what ever is there already

So rather doing it automatically, you run the macro manually to get the results you seek

Hi Rizvisa1

I have created the workbook and worked out the functions for the staff tabs and created a function that when they input a completed date it moves the row from there tab and moves it over to the archive, the only thing i cant seem to do is create a rule to duplicate there work over to the master tab which will hold everyone's work load?

I am sure your right i need a macro to do this but i im not sure how to do this can you advise me please.

I could always send you the file to show you what im trying to create?

Regards

Paul

I think I have not been able to highlight a issue
Lets say your sheet has 5 columns

When is the right time to move the data to Master sheet. Lets say you say when all 5 columns are filled. This means that as soon as all columns has some data (right or wrong or incomplete or complete) the data will move copied. Now lets say you edit one of the cell or clear out the cell. Later in the point you again filled in the cell. Now how can one say that this row has been already copied or not. May be I am over thinking here

Hi Paul,

Although Rizvisa is trying to inquire more information, you are not really answering his questions.

Myself am confused about Master and Archive sheet and whether you want to copy or move.

I'm still asuming you want to copy newly added rows to the non-master and non-archive sheets and paste them to the Master sheet. My idea would be to do this when closing the file.

If this is OK then provide your workbook using a filesharing site like
www.speedyshare.com
so a more specific code can be written for you, since you said you don't have much experience with Excel.

Best regards,
Trowa