Automatically copy row of data from Master Sheet to other sheet based on column criteria

I just attempted to upload the updated sheet. I apologize for not having that in there in the first place.
The decimal numbers in some of the sheets were to indicate when two people were listed in Column E on the Master Sheet.
For my purposes, every column could be copied into the appropriate sheet.

Hi Tiller332.

Welcome to the Forum.

You could achieve this using Pivot Tables.
All the various Sheets would be automatically populated.
Are you "comfortable" with Pivot Tables ?

Regards

peterrc

Originally Posted by Mumps1

OK. I would still need to know if you always enter data into column B and column E or if you sometimes enter data in only one of the columns and not the other before you want that row copied to the appropriate sheet. Also, I have to go out for an appointment now so I will respond as soon as I get a chance.

I apologize for not answering that. I thought I had. I appreciate your help.

Columns A thru H will always have Data in them. Those will have data entered at the same time. The remainder of the columns may not have data entered in them but it won't hurt if that entire row, potentially empty cells included, were copied to the appropriate sheet.

Wow! Thank you so much for that!

I was definitely on the wrong page about the capability of Pivot Tables.

The decimal numbers on the individual pages were to indicate when another salesperson was involved with the deal (when there were 2 names in the "Salesperson" column on the Master Sheet).
Will the pivot table work properly if I added a "2nd Salesperson" column so that that row would be copied to the appropriate sheets of both Salespeople?
If so, I could then not copy the "No." column from the Master Sheet and just have a new "No." Column for each individual sheet so that each sheet could have its own proper sub count.

Does all of that sound like it would still work with the Pivot Table functionality?

Again, Thank you soo much for your assistance!

Hi Tiller332,

I don't forsee any problems in "sharing" the sale so the sale (including value)appears on both of the salesmen's sheets,
However, the total sales values on each of sheets would then be incorrect, i.e. duplicated.
Is the sale (value/commision?) "shared equally?
Plese advise.

Regards

peterrc

Originally Posted by xladept

Did you try my solution - what happened?

I did try the code in the module. I was unable to get a macro or function to run from it? I'll put that on end-user error though... I do appreciate the follow up.

Originally Posted by peterrc

Hi Tiller332,

I don't forsee any problems in "sharing" the sale so the sale (including value)appears on both of the salesmen's sheets,
However, the total sales values on each of sheets would then be incorrect, i.e. duplicated.
Is the sale (value/commision?) "shared equally?
Plese advise.

Regards

peterrc

The values would ideally be split if there were two names associated with it.
Could that be fixed by adding, yet another column, labeled "Split," to the master sheet that had a simple Yes or No answer on each row so that in each individual statement an if/then function could be used to automatically split the numbers before displaying? Or is that over complicating it?

Hi Tiller332,

Please see atached "Version 2" of the Pivot Table that I attached in #post 9.
Does this work for you?

Regards

peterrc

Originally Posted by peterrc

Hi Tiller332,

Please see atached "Version 2" of the Pivot Table that I attached in #post 9.
Does this work for you?

Regards

peterrc

I do like this one! This helps very much!

I can't tell you how much I appreciate this assistance.

I do have one question about the pivot tables. When I was playing with this on my own, I was trying to find a way for the filters on the individual sheets to work as "OR" instead of "AND." Is there a way do this?
Example: I had made two Columns on the Master Sheet, Salesperson & Salesperson2. When on the individual tables I tried to put both of those columns in the filters so that if a name (BARRRY for example) showed up in either column("OR) it would also show in that sheet. When I was trying to work with it, it would only seem to work as an "AND" filter. It wouldn't show anything unless that name was in Salesperson & Salesperson2.

Originally Posted by xladept

Hi Tiller,
In the VBE click on Tools-References and choose
"Microsoft Scripting Runtime" then that should let the program work

I'm still getting a runtime error.
I am putting in a row of data on the master sheet, then running the "copyfromdata" macro. I get a runtime error (#13) and it takes me to this line: If Target.Value <> "" Then when I debug it.
I'm quite positive that this is end-user error and I sincerely appreciate your assistance with this.