Microsoft Excel - Multiple Searches as opposed to having to individually CTRL + F

Each month I get a spreadsheet off my boss which shows monthly figures for all our customers. Every 1 on the team has customers assigned to them.

We then individually need to see figures for just our customers... on the report there are hundreds of customers. What I've been doing is CTRL + F and searching for customer account number. Works ok as finds the exact customer and I can then see corresponding column with monthly figure, I then copy the data and paste to another sheet. But this is time consuming.

Surely there is a macro or some sort of formula where I could put my 30 customers accounts number in and could run it and then excel sorts the data to just display what I searched for?

Use the Macro recorder function.  Turn it on, start performing some of your actions manually.  Turn it off and look at the code it generates.  You can start building your macro from there.

Yes, the task you need to complete can be fairly easily done in a macro.

Hi Owain,
Another approach might be to use match to find the position of your customers in the table and then offset to show the values in your own summary table.  Later today I might get time to put together a schema for you if you don't think you could handle it yourself.
Regards
Harry

Hi, Thanks for replies. I've figured out a macro to do the job. Will save everybody so much time. Cant believe the time they've wasted over the years, been in my new job a month and thought there must be a way lol

Glad you got it done with a macro.

I was going to suggest two additional ways.  using a filter to hide all but the customers you wanted to see, or if you were feeling up to it a pivot table, this is a little more involved but would probably work for you as well.

anyway glad you go it working.


Don