Every quarter, I have to do bonus statements for our sales rep. Part of that includes giving them the detail that make up their sales for the quarter. I have a master spreadsheet that contains all of the information for all of the reps. Normally I filter that for each rep, copy and paste their sales into their spreadsheet. Is there a way, in their spreadsheet, to write something that will pull their information from the master so I don't have to filter, copy, and paste for 45 different reps?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pull only rows from another spreadsheet that match certain criteria
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Yes...
Formulas do not carry over cell formatting.
This can be obtained by means of whole column references at the expense of efficiency.
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I have attached 2 files. Commission Log Example is the file that contains all of the commission log entries. Earnings Statement is what we would generate for each rep. We would want to be able to change the Rep and the Payroll Date in C1 and C2 on this sheet and have it pull from the Commission Log Example based on that criteria.
The Earnings Statement is currently set up to pull based on C1, but we need to incorporate C2 into the criteria as well.
How would we do this?
Earnings Statement Example - New
Commission Log Example
https://www.dropbox.com/s/hmhgpf846gzx46g/Earnings Statment Example - New.xlsx?dl=0
https://www.dropbox.com/s/54zuazomqeomoda/Commission Log Example.xlsx?dl=0
Upvote
0
Similar threads
- Question
