En cours

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 : excel vba code, so ben, first code, vba for, vba create folder, uses excel, server code, new excel, in vba, excel uses, create folder vba, vba code excel, vba excel, save excel, excel vba, create excel worksheet, share save, excel 2011 vba, data processing vba, data entry worksheet excel, excel vba processing, excel additional, vba data processing, excel insert value, list code

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

N° du projet : #1068354

Décerné à :

ByronCarr

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

30 $ AUD en 2 jours
(1 Commentaire)
0.9

9 freelance ont fait une offre moyenne de 76 $ pour ce travail

UmarMahmood

Please see PM for more details.

32 $ AUD en 1 jour
(27 Commentaires)
4.4
vgrichards

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)
3.9
Indispensable

Please see your PMB. Thanks.

30 $ AUD en 0 jours
(6 Commentaires)
3.5
ifaisal

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

30 $ AUD en 1 jour
(4 Commentaires)
3.4
PG89

Hi, Please check your private message box.

30 $ AUD en 1 jour
(2 Commentaires)
1.6
thisisbinoy

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)
0.0
LuisGutierrez

12 Years MS Excel and VBA eperience...

30 $ AUD en 0 jours
(0 Commentaires)
0.0
tuta2011

Good experience with VBA. already solved similar problem

250 $ AUD en 4 jours
(0 Commentaires)
0.0