Copy and paste certain values from one column to another worksheet?

Hi guys!

I am new to this forum and hope someone could give me a hand with following problem?

In a speadsheet I have following situation.

Column A
Bill Nr: 1001
Customer Nr: 101
Amount
Tax
Total
Bil Nr: 1002
Customer Nr: 102
Amount
Tax
Total

The Customer and Bill Numbers are in Column A but amount, tax and total are in other columns not always the same! Either in column B, C, D, or E

I am able to find with VBA the cells in column A what I am looking for but what I would need is that I have a new spreadsheet with Column A- Bill Nr; Column B Customer Nr; Column C Amount; Column D Tax; Column E Total,
so I can used it for access and be able to put into a access table.

Could someone give me a hand with this please? I had a similar but not the same question in a different forum but was out of luck and closed that thread! So I am hoping it is ok when I am asking for help here??
If not well then I just have to do it by hand but that could just take many hours as there are a lot of cells I have to get sorted.

Thanks!

Nice greetings!

Attachment 360268Hi again

I was able to fine a code which works and get me started on my problem...

Please Login or Register  to view this content.

As I am still learing with vba I am not sure how I could now change the code or adapt the code so I can find a string in column A but copy a different column in the other sheet ?
For example.
Excel.jpg
I hope the pic I have attached is ok like this?
What I like to achieve is to get Rechnung Nr: and what is below of it in a separate worksheet from column A onwards.. but also the Netto 20 % MwSt and Brutto next to it.
So I could use it for access.
Hope you can understand what I am after and hopefully someone can give me a hand with this please??


Many thanks to all you experts