Macro To Save Automatically

HI GUYS HAVE USED THIS MACRO BEFORE IN PREVIOUS SHEETS TO GOOD EFFECT

Please Login or Register  to view this content.

THE PROBLEM IS I WANT IT TO DETECT CELLS B69 OR B70 FOR A DESTIANTION AS IT IS
BUT I ONLY NEED IT TO LOOK UP CELL D8 FOLDER AND THEN SAVE IT TO THAT FOLDER

IVE TRIED EVERYTHING BUT AM STUICK

ALL HELP GRATEFULLY RECEIVED

So I Want It To Look For Cell D8 Then Look For The Job Folder And Then Save It There
And I Want It To Save As Glass To Be Split Remade

anyone please

Hi Roy
In This Instance It Keeps Saving Exactly To The Same Place Even When I Change My Job Number

I Basically Want It To Look At Cell D8 Then Look For A File On My Computer Which Has Its Destination At B69

Server/job File

Then To Look In That Cell D8 Job Folder And Put The Document In That Job Folder Under A Sub Folder Called Docs
Which It Does On My Other Spreadsheet But Not This One For Some Reason

Even Though The Sheet Is Different Its Basically The Same Principkle And I Have Changed The Cells To Suit

Thanks For The Reply

THIS IS WHERE I AM AT MO

Please Login or Register  to view this content.

Anyone? Please

Sorry Roy
Under Pressure From My Boss
No Offence Intended

Still Doing Same Thing Roy