Dear All,
I have searched and searched for some help to my question as well as purchasing John Walkenbach VBA book but, im still really stuck
I need a macro code that updates all data in sheet (Upload) to a new sheet (in the book under Master) although the file Master would be stored C:\WOR\SHARED-WOR2-A\Capital Delivery\Planning & Performance NEW\Performance & Planning\Programme\03. Year 3\Master.
I want the user to be able to press the upload button (on the sheet) and this will transfer all the data to the master sheet ( i will have 4 of these upload sheets). The data needs not to overwrite the previous data.
I can do this by recording a macro etc but want it to look more professional.
I have enclosed the book as an example, any help would be amazing!
first post so please be kind.
Also i am a regular on this as well i suck on VBA
Cheers
Upload_AS.xls
Bookmarks