I have a Workbook that that I use for quoting the first worksheet is where the data is entered and uses lookups to pull information from tables in other worksheets. I have put a command button on the first worksheet which I want coded so when clicked will do the following:
Save the active worksheet as the value in E7 and then clear the data from the original workbook and save.
The value in E7 will be in the form of a manual entry like RW257. This value needs to be saved in a folder on the server in a file named RW257 Ben Jones
file path =(S:\share\RoofworksData\Quotes\ProjectNumbers\RW257 Ben Jones)
This part I'm not sure if it is do able. On the first worksheet i have another command but that opens up a pop up menu
where I can create new category, and add additional products etc. What I would like to happen is when I enter a new category it automatically creates another worksheet named as the new category and insert category defined names List & Lookup fields.
Được trao cho:
9 freelancer đang chào giá trung bình $76 cho công việc này
I am doing data processing and excel job for last three years for different research Institute. You can rely on me for quality job in scheduled time.