Hi,

I was wondering if anyone could help. I have a spreadsheet which lists suppliers which gets updated on a regular basis. What I would like to do is have a macro which exports 2 column contents from that spreadsheet upon exit and enters them into another spreadsheet. This is so the linked spreadsheet is always up to date. Not knowing a great deal about Excel, I hope someone can help?

Thanks