...i need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as
I need someone to copy information from some websites. I was thinking of using a macro to extract data from a box score of an NBA game (for example [login to view URL]) and formatting it for subsequent use in Excel. The box score is always in the same format on the ESPN dashboard, but of course the link will change daily
...within next few minutes if possible i need all data in different columns of sheetA copied 43 times in sheetB, when i run the macro For example: sheet A: columnA columnB tex1 text1.1 text2 text2.1 then when i run macro, in sheetB i should get columnA columnB text1 text1.1 ... ... copied 43 times text2 text2.1 .. ... copied
Hello Freelancers, I want a macro or visual basic code to extract the data from PDF to Excel Automatically. I have PDF and sample. Dont get forget to mention you offer I think it is not more than an hour work. Happy bidding
I need the script of macro to sort my spread sheet. I need something that I can use myself on a daily basis. The attached file should be sorted based on the name of the city - which is part of the string in the first column. Each city should be sorted out to a separate sheet (if possible). Please type the word "Root Beer" at the end of your proposal
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns
I need you to create a macro for vehicle that are changed. For example, if a customer wants to replace a white bumper with black then a parts list is generated. From that list of parts a quote is created. Basically, it's a option pricing. If you think there is better way to do it on access or any other way then please let me know. I would like to
I have an Microsoft Word document and i want to add a dropdown list to one place on the document. It will contain 3 peoples names - Steven, Darren and Michael....If darren is selected (location A) on attached, then darrens email address needs to be placed in the footer (location B) and his photo shown on the document at location C. If michaels name is selected, his email address and photo needs to...
Excel expert needed for a small job Iv added a new column to my excel file and my macro has producted an error [login to view URL] Before macro use to produce a sheet with last weeks bookings now i want to create a sheet with some of the columns hidden. Should be an easy job and my budget is 20 or max €30
...click script(click every 3 minutes) or keyboard script (Ctrl+Tab every 3 minutes) to keep a desktop active. The catch is that this will run in an office environment that has a macro blocker in place. Simply put, macros or hotkeys don't work (AHK/Jitbit/etc). The only way for it to register input is from physical keyboard keystrokes or mouse movement. I
Hello there. I need help with VBA code in Outlook 2016 so that: When email from "no_reply@[login to view URL]" is received in mailbox, sub "OpenFile" is called. and msg is saved in "k:/files/" as "[login to view URL]". Date should be "year-month-day" and time" hour-min" thank you..
We have an existing macro in excel (created by another freelancer many months ago), that needs some slight modifications done. The macro It was designed to work with multiple .txt source files, but now the source file is just one big single .txt file. The existing script loads values from a .csv finance file and uses that to make calculations in a main
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
I create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
I have an excel file with 384 input columns and approximately 86000 data point. each row represents 1 second. I want you to write a macro that would take each column copies it and provides an adjacent column with 5, 10, 15, and 20 seconds delays. Simply the column gets copied, inserted next to the original one and the data is shifted down 5, 10, 15
Hi, I would need a quick VBA macro, The task is relatively straightforward: As per attached, there is an excel file with data only in two columns, A and B. For column A you have data for all of the rows, For column B you only have data for some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column
Statement of Work attached - this will be the whole project (with some potential small adjustments)
creating a new options to select by department or cost center or both
Dear Machine Learning experts, I am looking for a python based tensorflow solution which can classify images for the following cases. 1) Color-cast vs Non color-cast images 2) Black & White (or Sepia) vs color images 3) Blurred Photos vs normally sharp photos I have a database of 2000 images for each classes. The main challange here is as follows. Classic CNN architecture (or Inception-V3...
i currently have a file that after 10 days of a completion date the history move to the 2nd sheet. the problem i'm having is that the history overwrites the data and i want all the data on the 2nd sheet to stay and keep.
Super easy project. For the 2 sheets labeled "Purchase Letter -Peo" and "Purchase Letter - QC", create a macro on each sheet that prints all the groups individually. Cell A2 needs to change each time. The value in A2 goes: 1, print, 2, print, 3, print....and on until the end of the list. Please ask questions before bidding. Again, this should
...for my product to be sponsored at - and the yearly calendar is a simple macro coding where you put the events on a box on the right side and the dates on the calendar get highlighted. However, now the dates get highlighted only with blue color for the one blue box that the macro code includes. I need help to create new boxes to better categorize my
Hi, I'm looking for some macro code to create a report from a table of data. Currently, the table lists out transactions with a unique value in column A. What the macro should do is: (i) look through column A, and insert a row when it comes to a new value. (ii) it should then put in column a of the blank row the value of the cell above, and the
You previously created ASIN List Update V1. It takes several columns of data and turns them into multiple rows, but also attaches the 'brand' associated with the ASIN. I would like your help in automating several additional steps of my use of this file. It's probably easiest to show you a demo over video chat.
Need 3 files with macro excel forms for ques/ans/ explanation for answers/summary points/reference. 1. MCQ questions 2. Cases and upto 6 MCQ ques/ans per case 3. same as 2. but upto 8 MCQ ques/ans per case Be able to convert the above in a table format using macro functionality. please provide samples of excel macro forms so I can provide feedback
I am sharing a excel sheet Task (1-) Data for task 1 Create macro for expected result for data 1 when we take entry of date range "deldate" and click on macro button then it pull the related information from sheet "Data for task 1" Expected result for task 1:---- (a-) Yellow column is important for result... (b-) this is example of jobsite 1
...can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a couple
...errors and PPT cant refresh the OLE data from XLS file. We manually have to correct the file location for hundrets of datapoints in settings. Goal: I would like to have a macro which has two steps when file is opened: Step 1: Do you want to refresh the data from XLS file? - Yes – Go to step 2 - No – leave everything a it is. Step 2: Let customer
...rows (the amount can vary). I need a macro where I can decide a percentage value and then have that many rows removed RANDOMLY from the file. For example, if I set the random value to 20%, 2000 rows would be RANDOMLY removed. If I set it to 10%, 1000 rows would be RANDOMLY removed and so forth. I need this macro for future use and I need it done today
Create Windows Macro/ Bot Browse, Screenshot and OCR Selected Region Immediate start
Hi, I need a Macro to check if for each "ID" under column E, (Type) "Services" under column B exists. If it does exist, then any other row where Type <> "Services" for that same ID should be deleted. If type "Services" does not exist for that ID, then all rows for that ID should be deleted except one and value under Column C (Value) for that ID...
Hi there, I'm looking for a developer who can piece together a simple script or macro or app to grab data from CSV and post with that data on OfferUp. 1) You must be familiar with OfferUp app. 2) OfferUp App does not provide API. 3) OfferUp App require emulation of real mobile data entry, they do not allow for automation. 4) OfferUp is not a website
I need a Macro to check if for each ID under column E, (Type) "Services" exists, if it does, then any other row that has same ID should be deleted. If no type "Services" exists, then all values under Column C (value) for that ID should be deleted and replaced in one cell (whichever cell for that ID) by the amount that is in one cell in column D (amounts
Please see attached input spreadsheet and output spreadsheet. - Create new WS "Aggregate" & "Volume" - For each worksheet matching "Data-*" - Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS - Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS - Forward fill cells area matching "...