Hi
I'm an apprentice in VBA so I need your help.
I'm building a Workbook, from which I attach a small example. The data is fictitious, but the layout is similar. What I need is a MACRO to select the sheet and file identified in the UPDATE DATA, copy the new fields and replace them in the sheet and file identified. It can copy and replace just the changed fields, or it can copy and replace all fields. I know how to identify the sheet and file ( it's an archaic way, I know, but I don't know how to do it better ). My problem is how can I replace the old data by the new data in the same sheet and file.
Sorry for English, it's not my native language.
Any help would be greatly appreciated.
Thanks
Bookmarks