Saving Files In More Than One Location???

[excelneub]

Hello:
I would like to thank everyone who has helped point me in the right direction while I have been working on this file. Your help has been invaluable.

The last step in the file I have been working on to me is my most complicated b/c I would like to do several different things that all lead to one outcome. As I am new to VBA and creating MACROS where to start and how to finish seems like a daunting task for me.
What I would like to do:
1. Create a MACRO that will save my file upon the entry of new data in what I will call the "Primary Location", simultaneously saving the file to a "Secondary Location" as a back up. The "Secondary Location" will be on a separate drive as well as a removable storage disk, so in total three locations. The reason being for the three locations is: one is a protected drive which only managers have access to, the drive is located on the same network. The removable storage disk is for security reasons in case the primary drive fails and the fill needs to be restored.
2. Create a "Button" that will drop down to the next line data is to be entered and reset the courser to column "A" on that line. In total 27 people have potential to be entering in data to the spread sheet and having the button to do all this for them will make things (in my opinion) easier.

I've looked online and seen examples of how to save in multiple locations similar to this: I would just need to enter in the appropriate file path and be done. Would something like this work even with a removable storage drive?

Please Login or Register  to view this content.

What I've been unable to find is how to create the button to trigger this code. I've been able to create a button but that's as far as I've gotten, getting it to drop to the next line and reset the courser is where I'm stuck.
I need to note: due to how the document needed to be created for form and function, there are three lines that are merged and centered, and in the same row those three lines are un-merged in column "AC" (three seperate peices of data needed to be entered with in the location as the remaining data). I'm noting this b/c I'm fairly sure it will have an impact on how the button needs to be coded in order to do what I'd like to have done. Lastly there are 12 sheets in the document and one sheet which is where data is collected and calculated, I also have one hidden sheet for my drop down lists data. In other words if I'm somehow able to get this button and saving down where do I put the code to apply to all the sheets that have a button?

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[excelneub]

I have added to

Please Login or Register  to view this content.

tags to the code I entered in to my post. I didn't think I was posting a code for copy or testing only an example of what I was referencing. I will be more mindful in the future, thank you for letting me know.