Error rsh = Sheets(st).Range("A" & Rows.Count).End(xlUp).Row + 1

I am trying to have one sheet in an excel spread sheet (Form) where I input patient data.

I would like it to send to all information entered to NPI (sheet)

and From the NPI sheet I would like to be able to update the event type and it to be duplicated to its like sheet. for example if they are from event type massage it needs to go to the massage sheet. in order to track patients and where they are coming from. I would like them to be entered only once in to each sheet that corresponds so if I hit the transfer button or Done button it does not make multiple copies of the same patient

And From the NPI sheet I would also like to filter Status type. From the NPI sheet I will be inputting the data in this column ( I wont know the status of the patient until they complete there first visit) SO for instance a patient has converted it should be added to the converted sheet.


Example: of patient on NPI (sheet)

Name Last Name Event Address City Phone # Email Address Event Type Status
John Doe Ameritrade 123 red st Roanoke 817-413-1234 [email protected] Massage Converted


this patient would go in the would stay in NPI but would also be added to the following sheets
Massage (sheet) and in Converted (sheet)

I am newer to the macros and I am not really sure what to do at this point if someone could please help me it would really be amazing!

thank you so much
JC

I am having trouble with the transfer... when I put the data in to the form sheet and click done it gives me the error code. The data transfers to the NPI sheet even with the error just doesn't transfer past that for some of the sheets... some of them work but not all. I also need to enter more data each day and Im not sure what the data capacity is..

Hi Jacolett. Had some time today to try help with this. I can see you have 3 threads about the same, so it was a little hard to find out of what you want.
But here is what i got. You make the input in the form. It goes to sheet NPI. Without a star in column 10. When you press the button Transfer new, it transfer according to the input in column 8 and 9.
And add a star in sheet 10 to the transferred. It works fine i think. I have then added a new button, because for some reason, you maybe will delete a customer in Mastersheet NPI, or change the input for some there. And i this case you need to use this button. It delete all sheets (Not NPI) and update them all with all rows and input from Sheet NPI.

Hope you can use it. I think its ok and fulfill what you want.Have a nice day

Sincerely

Abjac

I really appreciate all your help but when i click transfer or update I get a compile error- cant find file or library so again I have no clue what to do!

thanks

Jocatlett

Can you please explain to me step by step how to do that! I am really new to macros

HI I can only say what xladept say its also working for me. You could upload the real sheet, how it have to look exactly. Then we can have a look and return it so its working.

Abjac