extract all numeric values in sheet starting with ...

[BarrieB]

Hello,

I'm currently having such a big backlog at work after a covid outbreak on our department and the pile keeps on increasing and increasing, despite already working 10 hours per day on average. There are so many manual acations required before an invoice can be processed, that I can't catch up with the workload and basically spend the majority of the day preventing suppliers from blocking deliveries to us.

Have made a few very simple macros in the past, but they were the most basic ones like clearing all content from the active worksheet.

What I need the macro to do is:

Find and copy all numeric values in active worksheet that begin with:
- 19
- 81
- 450

Find and copy all words in active worksheet that begin with:
- KT
- WN
- TL

And paste them all into a new worksheet, listed in a separate column for each.

The data in those sheets will come from converted PDF files, so the layout will differ for each supplier, the cells can also contain other text and can be in merged cells as well.
I've attached an example of an invoice and marked the numbers that are to be extracted yellow.

 

[Peter_SSs]

Welcome to the MrExcel board!

You may notice that your thread title and your post have changed. To see why, review the Forum Rules but particularly #5.

 

[BarrieB]

Welcome to the MrExcel board!

You may notice that your thread title and your post have changed. To see why, review the Forum Rules but particularly #5.

That's been the problem I've been having everywhere... I've explained the situation and haven't found anyone willing to help, because I don't have the time to spend a lot of time on it myself.

Have been looking for over a month now and within that time my backlog has increased by 1/4, with a total of over 2000 outstanding invoices now.. That's why I want to offer compensation for anyone who can help me sort this out, so I can drastically reduce the time needed to process the invoices and finally start catching up again i.o. the other way around

 

[Fluff]

Why not get a consultant to do it for you? You can find some here

Consulting Services

Are you stuck doing a tedious manual process day after day? This can be automated using VBA macros behind your Excel worksheets. For over twenty years, these Excel consultants work with customers via e-mail or telephone to build a solution.

www.mrexcel.com

 

[Peter_SSs]

... haven't found anyone willing to help, ..

Not sure if you actually read the rule I pointed you to, as it has a link in it for somewhere where you could get paid help.
Anyway, Fluff has reproduced it directly here now for you.

 

[BarrieB]

Why not get a consultant to do it for you? You can find some here

Consulting Services

Are you stuck doing a tedious manual process day after day? This can be automated using VBA macros behind your Excel worksheets. For over twenty years, these Excel consultants work with customers via e-mail or telephone to build a solution.

www.mrexcel.com

Thanks for the help, I overlooked that part in the forum rules. Have messaged one of the consulatants