Objective: We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run
...matched to the budget, then approved by Manager and to check that relevant revenue invoice pertaining to particular costs has been invoiced out. At present we are using excell as per attached but it is very cumbersome and difficult to keep track. You will note the different months schedules. There is a schedule for actual and another for budget
Need an excel macro to get prices from website into excel
Financial/Business analyst ,Excel Macro expert needed for some task .
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format protection locked. Cell W38 has ...
I would like the highest and lowest rating in column R found and the the whole corresponding row copied to a blank sheet. This needs to be done for all sheets in the workbook. Please check screenshot for more information.
hi, I want to make a simple system allowing commercial team to generate quotes o...based on our Price List. They have Android tabs and phones so I want it to work with these equipment, but it could be "on line" if needed. We have built a calculator based on Excell but it can not work under Android. Quite simple project if you know Android capacities.
I am using Windows 10 and Microsoft Outlook 2016. I receive an email every morning that contains 25-100 links with data on real estate. 1. Each link in the email needs to clicked on, and then the subsequent page needs to be printed to PDF. I would like to have each file labeled with the current date, then “(LN)”, then the id used in the source
...(PRODUCTION) C) IT WILL BE STORED ON A NETWORK D) WHEN SOMEONE GOES IN TO MAKE AN UPDATE, I WANT THE MACRO TO DO THE FOLLOWING: 1) SAVE THIS ORIGINAL MASTER FILE ON THE NETWORK (I'LL UPDATE THE ACTUAL PATH, BUT I'LL NEED YOU TO SIMPLY WRITE C:PATH IN YOUR MACRO, OR SOMETHING SIMILAR) 2) COPY THE PARTICULAR SHEET THE END-USER IS CURRENTLY EDITING TO A NEW
I receive a PDf every week and I need to copy the sales data from the PDF to Excel. I am looking for a Macro that can automatically copy the data and format it into the excel table. please see the attached PDF. I need the data from Page 3. Do not BId more than $30 as that is the maximum budget or else i will delete your BID. Thanks