I am extremely new to Macros and VB. As a matter of fact, it is a miracle that I actually found what I needed, put int in my spreadsheet and had it working, until others started using the spreadsheet. I don't know what went wrong where. Essentially, I had the following code written: Sheet 2 is 2014 Investigations and sheet 3 is completed investigations. I wanted a row from sheet 2 moved to sheet 3 when an x is placed in Column Z. If I get this functioning once again, what will happen if I add another column?
This moved a row of data to a new worksheet labeled Completed Events when an x was chosen from a drop down menu in row z. It no longer works and I can't figure out how to fix it. Sheet 2 is 2014 Investigations and sheet 3 is completed investigations. I wanted a row from sheet 2 moved to sheet 3 when an x is placed in Column Z. If I get this functioning once again, what will happen if I add another column?
Please help..........
Bookmarks