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.

Compétences : Traitement de Données, Excel

Voir plus : 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

Concernant l'employeur :
( 30 commentaires ) Wandi, Australia

N° du projet : #1068354

Décerné à :


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

30 $ AUD en 2 jours
(1 Commentaire)

9 freelance font une offre moyenne de $76 pour ce travail


Please see PM for more details.

32 $ AUD en 1 jour
(27 Commentaires)

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 en 1 jour
(21 Commentaires)

Please see your PMB. Thanks.

30 $ AUD en 0 jours
(6 Commentaires)

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

30 $ AUD en 1 jour
(4 Commentaires)

Hi, Please check your private message box.

30 $ AUD en 1 jour
(2 Commentaires)

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 en 7 jours
(0 Commentaires)

12 Years MS Excel and VBA eperience...

30 $ AUD en 0 jours
(0 Commentaires)

Good experience with VBA. already solved similar problem

250 $ AUD en 4 jours
(0 Commentaires)