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