... Cells(8, 24).Value = "" Else Cells(8, 24).Value = Format(Now, "HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happens on (Cell B) which is based on formula which is on (Cell C) i want to link entire
I have few recurring excel tasks that need to be automated using VBA - Basically/data to charts using pivots and VBA
I need a well experienced VBA programmer. Who is familiar with connecting to websites through API and Parsing JSON responses. More details will be provided on private chat discussion.
Working with Outlook 2010 - Inbox and any sub folders. Have set up various Categories, which are assigned to an email via Quick Steps. When s...assigned to an email via Quick Steps. When sorting by Categories I want the 'Done' Category to Collapse, so that no Category 'Done" is visible. I assume that it will require VBA, but open to other options.
We are looking for Freelancers that can help us in building a solution where we can upload products from an MS Access database to WooCommerce using their API. [ログインしてURLを表示] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include images for these products. 2. Update Qua...
I have multiple mdb files that need to be combined into one and filtered out. I need a access vba to combine all files together and select records every 10 records from the combined one.
Hi, I run a warehouse. In order to manage our inventory dispatches to our customers, need to build Excel tool (using VBA and macro) for inventory management. Need someone who is very good with VBA and excel macros. Thanks
I need experienced freelancers for my few projects on Excel VBA, Macro .
I need a salary tracker, that will determine my gross and net pay also will counts days worked. I need this to also once it get to 170 days worked, on the 171 day plus wi...hours, it will calculate a set day rate . I'm including this sheet as a guide, but I'll be looking for something new from you, not the same one. You will need to be able to do VBA
I have a database with the Tables in it. I need work done in Macros and VBA. No SQL. See the Attached Power Point for Project description and See the Access Database and Excel workbook for examples and more explanations. I need this in the next two days ( I need it Tuesday). If your late I will give a rating that reflex that it was finished late
Hello, I need someone to create a VBA script for me that copies some text from one word document into a row in a table on another document. More information provided to successful bidder.
Looking for freelancer who is well versed with Excel VBA to be used on simple finance question. Looking for someone who can help code out NPV and IRR values for the scenarios, create a graph visualizing the NPVs. Drop me a message if you are into this
...in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes....
its a small project for that i volunteer for
VBA for excel is required. Need to create some Micros for excel.
This request is for a MacBook! I have a folder with several su...folder with several sub folders, and sub folders within those folders. In these folders I have several excel files. The excel files all have the same format. I need to compile certain cells from each file into a table. I don't know how to write the VBA code and need help. Thank you
I have this worksheet with dates in column B, and name in row 1 and sub headings in row 2. I have set up this userform, so the user can select a name, choose a tra...have also defined the name row as name in the worksheet. And here is the code I have developed so far, could someone please kindly give me some advice as I am very new to this VBA coding?
I need certain quite simple VBA macros written, which mainly do copy/pasting from excel file to another excel file, number searching, etc, quite simple operations. I will be available online as you work, so you'll receive all guidance real time. Project starts asap.
myself karthik - i am staying at Dahisar East, I want to do a invoicing project using excel VBA
Will discuss over chat i have lot of work to discuss
Expert experts needed (more details will be explained to the selected writer
Need to create macro for excel connect to Bloomberg you need to be in Dubai
Construction business and we use Excel to create estimates. When creating estimate for complex projects we often create multiple tabs on same worksheet (create copy of original) to mock up different options for customer. Would like to use VBA to create a 'Comparison' tab which shows the highlighted cells (yellow) for each of the tabs on file. I have
In my company, we use a macro PPT and EXcel to help us copy/paste elements ; we’re experiencing bugs and need the support of an expert in Microsoft VBA programing to refactor in full the current macro. Need a native French speaker to run the project.
I am on Microsoft Visio 2010. I need a module written to sort all of the sheets in my workbook alphabetically. There are over 300 sheets. The data is sensiti...for someone in the know, I found a guide online but couldn't get it working. [ログインしてURLを表示] Thank you
CONVERTING EXCEL SHEET TO PDF AND EMAILING DIRECTLY WITH ASSISTANCE OF VBA, ALSO SUPPORT WITH A PRINTING OPTION
Hi, I need an Excel formula or VBA function that will extract all occurrences of a string, it’s an src=“[ログインしてURLを表示]*/*” string, where the * can be different text. There can also be multiple src strings in one cell. I need all the src strings to be copied into a new column. File will be shared in messenger.
...minute promotional video for a VBA application that I seek to develop into a mobile phone application through using crowd funding. The VBA application is already developed and a video of the working prototype will be used in the promotional video to encourage people to support making it into a mobile application. The VBA application runs over the course
I need someone to build a macro for me that can enter customer data from excel into a webform The form consist of 2 drop downs and text fields. After submission there is a popup where you have to click OK then another confirmation where you have to click OK. should be simple. I need it to add the word complete to an open space in the spreadsheet after
I need someone to build a macro for me that can enter customer data from excel into a webform The form consist of 2 drop downs and text fields. After submission there is a popup where you have to click OK then another confirmation where you have to click OK. should be simple. I need it to add the word complete to an open space in the spreadsheet after
VBA Code for Form Filling, from an excel table Hello, I'm needing a vba code that fills out a form on a page on my company's intranet. We are talking about a Human Resources sector In excel I have the personal registration(ID), name, note and description On the intranet page, the code needs to copy the excel personal registration(ID) and click on
Hello, I'm creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page.
...not automatically update so I currently have a Word based VBA macro which does this for single file the when the code runs – it also applies a standard font to all the text. Then it saves the file and closes it. All I require to do is automate this by replicate this code within VBA Excel for all Word files in a selectable folder. Typically 100 Word
Hello, I have a table in s...Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe via VBA or Macro. So that always when the sheet 1 1 is being replaced by a new report I click on a button in sheet 2 and it gives me what I want to see.
Complete an excel report with [ログインしてURLを表示] details will be share with candidate
I need someone to create an Excel staff training database. I have been following a tutorial ([ログインしてURLを表示]) Please see video for the functionality i am looking for [ログインしてURLを表示] I have already created a workbook and a User Form in Visual Basic, but i cant program
COMPLETING AN EXCEL REPORTING WITH ASSISTANCE OF [ログインしてURLを表示] DETAILS CAN BE SHARED TO APPROPRIATE CANDIDATE.
Hello, I'm creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page
hi guys i need a vba code which will spilt the file into multiple PDF file based on Heading and sub headings in word doc. Also it would save the file based on heading as file name and make sure heading title does not change.
I've got Excel VBA code to web scrape. I now need to use proxies and speed up the process. Should be easy for someone who's done this before. So I just need the Excel VBA code snippet to use proxies. The proxy list can be in an excel file as attached. I've attached a file to explain. 1 - get url 2 - get proxy from list 3 - use proxy to get data ...
I will make payment on hourly scheme ONLY through the website. No direct payments will be made including through paypal or some other similar option. The data can contain upto 4000 rows and has two columns – date and value. Input date I1 has to be validated and the user should be prompted to enter the date in the range or exit the program without crashing. First purchase of quantity I2 will...
I need to learn Excel VBA macro for project development.
Existing spreadsheet used for financial management (labor, expenses) for program management needs updating for reporting/graphing and better management.
I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
An excel file with 11 tabs. The coder will create code so the user can add and delete rows with specific characteristics The coder will create code so the values entered in certain fields are summed to other worksheets
Hi, I need someone to help with the creation of 5 spreadsheets. I attach one template for reference. I need this for: English Premier League English Championship Italian Serie A Spanish La Liga German Bundesliga I need to pull in fixtures from the below link to my spreadsheet. This file will need to be filtered depending on the Spreadsheet template being used. [ログインしてURLを表示] For example, for ...
GPA Calculator: I have a GPA Calculator developed in Excel which uses simple functions and few VBA codes. Task is to bundle this into an app for Android (and maybe IoS) and publish in respective stores.
Can automate almost each steps in reporting which are repeatative through VBA Excel. With unique and user-friendly design.
