Mengkonversi macro excel yang telah dibuat menjadi aplikasi stand-alone yang kemudian dijadikan add-ins. Script macro excel sudah tersedia. Contoh program stand-alone yang diinginkan adalah crystall ball.
I have a workbook t...want to use formulas in the mastersheet to copy and sort the data into the appropriate cells on the daily sheets. (sort by date to get the data onto the correct sheet, then copy to the range for each office location). Due to security restrictions, I can't save excel files that contain vba code. I can use excel formulas however.
I have an excel spread sheet what was given to me and it performs some calculations. I need the excel formulas for each cells written down. At the moment I’m don’t know how to translate the excel formula so I can do the same calculation using my calculator. I can send the excel spread sheet through to you. I need this done as soon as possible
I have several excel spreadsheets that have different column formats. However they all have an email column with email addresses. Next to the email column there is an email format column. I would like a script that would read from the email column and then add in the email format column a string of characters that will explain how the email is construed
I need about a 4 step macro done. #1 AK&AJ copied to a new sheet 100 lines #2 Auto Sort AK&AJ,#3Add duplicates together.#4 at the part number colum A add a comma and then value in colum B so we end up with example R72653,2
NU 576 Excel Workbook Exercise The purpose of this exercise is to familiarize you with the effective use of Excel as a tool to manage finances and numbers. You are to create an Excel worksheet that demonstrates a staffing plan with salary information for a small hospital unit. The Unit is staffed in three 8 hour shifts. There is 1 nurse manager who
I looking to add the regulatory r...the regulatory rating for around 450 hospitals in the UK. This information is contained on the home page of the hospital. 450 searches using an excel file I will provide. The freelancer needs to copy 3 cells into google and then return the rating that is displayed on the homepage. I reckon it will take 3-5 hours.
...to this level, and research and development is underway to further decrease the cost of production. New materials known as perovskites have been incorporated into solar cells and have increased solar cell efficiency in laboratory tests, from a 3.8% efficiency in 2009 to just over 40% by 2018. If technological development in solar continues at this
I want a macro or something for Google Chrome which can simply : 1. Take to a fixed URL. 2. Click on 'Choose File' at a fixed point on the webpage, 3. Selects a fixed file at a fixed destination on my MacBook Air Laptop. 4. Click on 'Upload' Button. Auto repeats the above procedure at a fixed interval as set.
I have a project where the person needs to be extremely good with Excel Macro. The work is 50% complete.. need a person to complete it. please do not BId more than 3/hour otherwise ill ignore it. Thanks
I have a macro that scrapes a website for data and saves it to Excel. The macro uses IE which is slow. I would like to have the code changed from using IE to chrome. The code works, so just a conversion exercise. Budget is A$25
I have two excel files 1) Excel file that has input data - it is in a worksheet but worksheet has several sets of columns and different types of data 2) Excel file that data must be inputted into. The excel file is large but I want it to be populated into this excel file but only in a pre-defined area. I need this task done ASAP Let me
...easy quick excel macro that does the following. It is urgent and i hope to have this project done today in a couple of hours. Macro should take contents from column A and split them at character " - " and put first half of contents into column b, and other half into column c. we should have a button on the page to click to run the macro. code should
1st macro will be on the supplier timesheet itself where there is a button. When the button is pressed this will send the 'supplier timesheet' to a specific inbox. Also provide a message that this has been sent to the sender. 2nd macro 'weekly supplier posting' . Majority of the work. So the file sent from each supplier will end up in a specific
I need Macro to finish the job automatically . Open Invoice (template1 ), i will input all data in sheet "INPUT"Row 1-100 The Macro can according to PI number at Cell A1, C1,E1 ..... and lookup data ITEM NO, QTY, DESCRIPTION, UNIT PRICE ........ from "connect [url removed, login to view] Sheet MPRO_INV , [url removed, login to view] Then output...
...generates every morning from my headquarters. I have created a macro that I run on that report. One of my employees gets the same report, and I would like to give her the same access to my macro, without having to recreate it on her machine. Some notes -- 1) I cannot load the macro on a flash drive -- we are a bank. Our PCs don't like flash drives
I am looking for a Outlook macro to save chosen emails and their attachments. The use will click a hot key to start macro and a dialog box will display a list of projects and projectID's from a table in SQL server. The use will choose the project that the email relates to. The macro will then check to see if a folder exists with the ProjectID name
...Person who is strong in EXCEL MACRO. Make presentation automatically with specified format presentation from Excel workbook. Input : 1) Presentation Template 2) 2 Excel Sheet Output : Macro - Should create automatically presentation Chart and test from the 2 Excel sheet. I will give 1 presentation and 2 Excell file workbook. Macro Should create s...
...a simple project for work to be done to create a macro that will export to PDF,EXCEL and WORD. I have attached the Macro Instructions in a word document along with the excel file. In Summary 1. When a user runs the macro it asks them to select a format to export a single sheet to e.g PDF,WORD,EXCEL 2. It then create the file with the sheet. Deta...