hi,
I am trying to make a macro that saves a file by a click of a button and with the same name as the master file with a numeric system in a custom location, but I can't seem to figure it out.
Example
masterfile= Salary
user 1 changes data in Salary then clicks a button
file is saved as Salary 1 in a different folder.
-----
user 2 changes data in Salary and clicks a button
file is saved as Salary 2 in a different folder.(same folder as salary 1)
and so on.
Hope this makes sence
Hond
Bookmarks