DemonCipher13
New Member
- Joined
- May 6, 2014
- Messages
- 14
This one is a complicated question.
I have several spreadsheets that are added to, subtracted from, and changed daily.
These spreadsheets list the location and information of various tissue samples - I work in the medical field.
There are two types. Type A: The pre-existing spreadsheets, which need to be kept, but updated. These are organized by type of tissue. Then we have Type B: The new, updated spreadsheets. These are organized by Freezer.
Both sets must remain, but I want to have the data 100% accurate in the Type B spreadsheets, input said data into the Type A spreadsheets, and eliminate the need to update two, or three, or four separate spreadsheets at the same time. I want to simply go to the appropriate Type B spreadsheet, add or delete from the data what I will, and know that it will be automatically added/deleted/edited from/on each of the others.
Now it needs to be mentioned that there is a huge amount of data on each of these spreadsheets, approximately 5000-10000 rows apiece.
I hope there is a macro that can be developed, but it would expedite work around here so much, as well as ensure the maintenance of accuracy.
What can I do?
I have several spreadsheets that are added to, subtracted from, and changed daily.
These spreadsheets list the location and information of various tissue samples - I work in the medical field.
There are two types. Type A: The pre-existing spreadsheets, which need to be kept, but updated. These are organized by type of tissue. Then we have Type B: The new, updated spreadsheets. These are organized by Freezer.
Both sets must remain, but I want to have the data 100% accurate in the Type B spreadsheets, input said data into the Type A spreadsheets, and eliminate the need to update two, or three, or four separate spreadsheets at the same time. I want to simply go to the appropriate Type B spreadsheet, add or delete from the data what I will, and know that it will be automatically added/deleted/edited from/on each of the others.
Now it needs to be mentioned that there is a huge amount of data on each of these spreadsheets, approximately 5000-10000 rows apiece.
I hope there is a macro that can be developed, but it would expedite work around here so much, as well as ensure the maintenance of accuracy.
What can I do?
