Excel Spreadsheet Macro - VBA
I need a button installed in K1 called "Lock Open". To the right of the button, you see the number 5 and the letters F,N and V each in their own cell. When the button is pushed I need the values that reside in columns F, N and V to be moved 5 columns to the left. These settings can change. At some point I may change the 5 to 6 or the column letters to other letters. Need to make sure we store the values at the time the button is pushed keeping in mind that the values are coming from cells that have DDE links so I don't want to push the active links. I just want to grab the value from the column and store it 5 columns over. The values that should be pushed will be in row 2 through the first empty row. So right now row 18 is empty which means right now, if the button were pushed it would effect the data in rows 2 through 17 of the F,N and V Columns. I also need a reset button put in J1 that puts all values that were previously moved back to 0. This is not to reset the "from" columns (F, N or V). This is for the "to" columns that store the data. Desired Skills: VBA Keywords: Software Application, VBA
| Expired |
Louis Postel
Blog & Content Writer
View profile
Hayley Timmons
Writer
View profile
Roger Harris
Copywriter
View profile
Sherry Leak
Illustrator
View profile
More vba projects
View AllRelated projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."