Creating a Master Database with linked columsn

[Cogito13]

Hey guys,

My name is Grey, and I am new to this forum. I must say that you guys are doing some excellent work!

I am in sort of a pickle. I am working on creating a medical master database. I have a master sheet with a huge number of columns. I have a couple of guys working with me, and they have their own sheets in the workbook.

So here is what I would like to do: anytime one of the guys enters data into his respective worksheet, I want the data to be copied over to the master sheet in a new entry.

The columns among the worksheets are different, and I would like the data to automatically sort in the appropriate column on the master sheet when it is copied.

I have attached a copy of the workbook. Please let me know if you guys need any further clarification.

I have included an example of what I would like to see. For example, if Charles puts in an entry in his worksheet, a new entry is created on the master sheet with the information from Charles' sheet sorted in the appropriate columns.

Thanks!
Grey

[rcm]

Using a macro, I highlighted the fields that are going to be recorded into the master tab from the 3 other tabs C for Charles, W for William, A for Adam.
The field Blood Pressure 2 is not a field in any of the fedder tabs.

I use the name of the fields as reference so there has to be an exact match

[Cogito13]

Thanks for the quick response! I deleted the Blood Pressure 2 field; it was accidentally made.

The macro doesn't seem to work though. If I enter data in any of the feeder sheets, it doesn't transfer them over to the master sheet when I run the macro.

Maybe I am doing something wrong. Thanks for the help!

[rcm]

No you were not. The first macro was only to see it all fields had a match... I forgot to mention it.

Here it is...

I try to make it flexible enough so fields can be added in the master tab when necessary.

The Data tab reflects were all fields go and the numbers underneath them represent the column in the master tab.

After a row is entered a posting mark ("***") is placed at the end of the record so it won't be recorded again into the master tab.

If you want to rebuild the entire database, just delete the posting marks from the records..

[Cogito13]

Works like a charm! Thanks, repped you. Just a sidenote, is it possible to remove an entry from the master sheet after it has been deleted from one of the feeder tabs?

[rcm]

For that, a unique record identifier would have to be built into each record in the master and in each of the feeder tabs.

[rcm]

In the mean time, there are two fields that have no matching fields in the master SCV DT which I renamed SCV DATE, and xray Date.

Expanding on the previous post, the identifiers would be built automatically. I'll work on it.

[rcm]

I coded so that if a record has to be deleted just insert "xxx" in the column A of the tab and run the macro.

The macro will look for that and delete the record in the tab and in the master tab, if there are new post it will post them into the master tab too. It is a one for all type of thing.

[Cogito13]

Thank you so much!