Hi Folks,

The Following Is What I Am Looking To Do.

Sheet 1 Users Enter Information, Some Of Which Gets Populated On Sheet 2

I Would Like A Button Placed On Sheet 1 Which Launches A Macro And Does The Following
  • Populates Certain Cells On Sheet 1 With A Default Value If Fields Are Blank

    Carries Out A Global Find And Replace Of Certain Values On Sheet Which Are On Sheet 1, For Example Changing Everything Dated 01-01-1900 With The Contents Of Sheet A6 etc.

    Outputs The Contents Of Sheet Two Columns E1:E5,F1:F220,G1:G220,H1:H220,I1:I220 To A Text File, In XAI Format If Possible

Any Help Greatly Appreciated.

Thanks,
Mark