Two Separate VBA Statements That I'd Like to Run Together

Hello,

This is my first time posting and I am also VERY new to VBA.


My overall goal is to copy and paste data on my "Master Data" tab into a "Master Data History" tab and then clear the contents that were moved from the "Master Data" tab. The data that would be moved is flagged in Column K with an "X" - once Column K is flagged "X", the information from the row from Columns A:K would all be moved to the "Master Data History" tab.

After doing some extensive research on the forums, I was able to find and tailor a two bits of coding that work the way I would like them to individually, but I can't figure out how to get them to run simulataneously one after the other. Is this even possible?



First code (copies data from A thru K in a row that is flagged "X" and pastes in last row on "Master Data History" tab)

Please Login or Register  to view this content.

Second code (clears contents in Columns A thru K on "Master Data" that has been flagged with an "X" in column K)

Please Login or Register  to view this content.

Lastly, if possible, I would also like to add a code that would autofit columns to all data on both tabs.


I apologize in advance if this isn't very clear and will gladly answer any questions that would help clarify the ask.

Thank you

Code Tags Added
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 at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

You should be able to make this happen by taking the code below (from your second event) and pasting it

Please Login or Register  to view this content.

just before the line of code

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.