Ok, so the formula works that i was having issues on but am curious if there is a way to use a macro to automate my task. I have 6 sheets in my workbook. First sheet is a dump list of 3 columns. A is the name, B is number of sales and C is cost of each sale. The other pages are used for ranges. aka if under. 80 then A1 (the salesmans name) goes here. If range is between .81 and 1.30 it goes to second page and so on...I don't know anything about vb so hoping someone can point me to a sample as a good starting point or something... Thanks in advance.
-
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.
Macro Question for excel
- Thread starter ceyoung75
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
If I understand your correctly, I don't think you need VBA at all. Just one FILTER function on each sheet, specifiying what data from your main sheet to pull.
(The new FILTER function in Excel 365 is a great tool for projects like this!).
If it dynamic. So all you need to do is enter one Filter function on each sheet, specifying the filter details, and it will return all matching data.
See: FILTER Function
(The new FILTER function in Excel 365 is a great tool for projects like this!).
If it dynamic. So all you need to do is enter one Filter function on each sheet, specifying the filter details, and it will return all matching data.
See: FILTER Function
Upvote
0
