Đã hoàn thành

Excel 2003 VBA Code

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.

Kĩ năng: Xử lí dữ liệu, Excel

Xem nhiều hơn: vba command button code excel, excel vba code, worksheet data entry form vba code, what is manual data entry, so ben, first code, excel data entry worksheet form, data entry form excel 2003, create excel form for data entry, create data entry form in excel, excel 2003 data entry vba, excel 2003 vba data list, what is vba in excel, what is vba, vba for, vba create folder, uses for excel, server code, new excel, in vba, excel uses, create folder vba, vba code excel, VBA and excel, save to excel

Về Bên Thuê:
( 30 nhận xét ) Wandi, Australia

ID dự án: #1068354

Được trao cho:


I'd really like to help you out with this request. Please see PM.

$30 AUD trong 2 ngày
(1 Nhận xét)

9 freelancer đang chào giá trung bình $76 cho công việc này


Please see PM for more details.

$32 AUD trong 1 ngày
(27 Nhận xét)

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 AUD trong 1 ngày
(21 Nhận xét)

Please see your PMB. Thanks.

$30 AUD trong 0 ngày
(6 Nhận xét)

Hello I can do this for you, please see my private message for more details. Regards Faisal

$30 AUD trong 1 ngày
(4 Nhận xét)

Hi, Please check your private message box.

$30 AUD trong 1 ngày
(2 Nhận xét)

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.

$220 AUD trong 7 ngày
(0 Nhận xét)

12 Years MS Excel and VBA eperience...

$30 AUD trong 0 ngày
(0 Nhận xét)

Good experience with VBA. already solved similar problem

$250 AUD trong 4 ngày
(0 Nhận xét)