Hi guys
I have a spreadsheet which contains a list of high level information. I have set up code and buttons on screen to allow the user to create a detail sheet for specific information.
However, as my VBA skills are limited at the moment I have developed the code to operate just for one row and am unsure how I could set it up for multiple rows.
What the code does is take a cell value and create a new worksheet with the name defined in that cell. It then copies a format from a master format sheet which the user can then populate. So, at the end of each row I have a two buttons…one to create the new sheet and then one to view the sheet for that specific entry. I would like to have these two buttons on all rows with each referring to the cell at the beginning of that row. Sorry if this is confusing.
It would be similar to having a list of numbers and then typing a formula into the adjacent cell and then dragging it down of get a list of answers…only in my case it’s buttons and code.
Any ideas would be greatly appreciated.
Thanks
Dean
I have a spreadsheet which contains a list of high level information. I have set up code and buttons on screen to allow the user to create a detail sheet for specific information.
However, as my VBA skills are limited at the moment I have developed the code to operate just for one row and am unsure how I could set it up for multiple rows.
What the code does is take a cell value and create a new worksheet with the name defined in that cell. It then copies a format from a master format sheet which the user can then populate. So, at the end of each row I have a two buttons…one to create the new sheet and then one to view the sheet for that specific entry. I would like to have these two buttons on all rows with each referring to the cell at the beginning of that row. Sorry if this is confusing.
It would be similar to having a list of numbers and then typing a formula into the adjacent cell and then dragging it down of get a list of answers…only in my case it’s buttons and code.
Any ideas would be greatly appreciated.
Thanks
Dean