Wir sind in der Baubranche tätig und haben eine Kalkulations- sowie eine Angebotserstellungs- und Rechnungserstellungstabelle im Excel erstellt. Es gibt ein paar Details, die wir gerne ändern möchten. Hierzu sind VBA Kenntnisse erforderlich, die wir in der Firma nicht haben.
Simple project. I need it to process all xls files in the directory, one by one. Directory is selectable the worksheet in all files is Sheet1 Select the date with datepicker format M/D/YYYY, this date goes in cell B8 Select week 1-5 are drop down selections. The 3 choices are Pending Holiday - When it saves the files it will create a new directory called Completed and save the f...
Preciso de um orçamento para a construção de um sistema WEB (preferencialmente) ou VBA (alternativamente). O sistema deverá ser acessado pela internet, porém deverá funcionar como se fosse uma intranet, permitindo somente o acesso de usuários logados com login/senha. O login poderá ser integrado com facebook/google/microsoft. O sist...
I am looking to be able to extract Google calendar information into Excel. In the code, I would like to specify the following: 1. Login information 2. From date 3. To Date The information I need back from the calendar is the following table: 1. Date 2. From Time 3. To Time (or duration) 4. Title 5. List of guests.
vba/ macro auto create tab, dropdown and sheet based on data. i have excel file, i would like to create macro/vba to refresh/create tab, dropdown, sheet based on 1 tab called data1. let me know if i can call to make it eaier to explain
We have a software, which you can output to excel data. We want a button in excel to run a macro or any other means needed, which will copy the data, open up a pop up window asking the user to input 3 texts, (and a question if we wish to split the text) then, automatically add these details and some of the copied detials to a master sheet, and print
I'd like to make Excel VBA available on spreadsheets. I will check the operation before delivery. If you pass it, the transaction is complete. Please give me the price in the bid price. Please do not negotiate to raise it any further.
...of jobs the technician sees in one day. It may be possible that there is a software available that can do this, but I haven't come across any specific to our needs. An excel sheet that automatically updates each time it is opened to create this priority list would help this business to complete jobs more efficiently. I currently have an idea of
Im using VBA in Excel to work on a fairly simple flow chart that i have created. I have 5 Variations of the flow chart that i would like to eventually test as part of my larger project. The data set im using is simply a range of numbers from Cell A2:A13. The numbers are to two decimal places. Because i have 5 flow chart variations of testing this number
Im using VBA in Excel to work on a fairly simple flow chart that i have created. I have 5 Variations of the flow chart that i would like to eventually test as part of my larger project. The data set im using is simply a range of numbers from Cell A2:A13. The numbers are to two decimal places. Because i have 5 flow chart variations of testing this