Hi all,

I'm completely new to VBS and need to complete a project by 9am (BST) this morning!
I've tried recording macros etc but just cant get what Im trying to do to work.

Basically I have a sheet on a workbook named 'transfer' It is auto populated from various sources. I trying to create script I can allocate to a button that will select all populated cells on the 'transfer' sheet and save them to a txt file need Transfer.txt

Any help will be greatly appreciated.