Wholesale/e-commerce clothing business based i... We download our orders off various websites into a excel file - each row is an order with details an individual header. 2. We would like to automatically created a new worksheet (template that we already use - formatted into a job sheet) from the individual rows of orders in the downloaded excel sheet.
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
...reflecting accurately at all times. B. This estimate of time on a call with be billable time only. Not hold, or anything else. Strictly billable time. 2. On Advisor public cells/profiles there should be a visual display "Approx Call Time(ACT)" which will show that calculated estimate call time for that advisor on their public advisor cell/profile.
I have a spreadsheet from my CRM. The term #FIELD! is where the cell phone number is normally. When you click on those cells the number appears in the box above. I want the number to be visible so my recruiters can call right down the list. Please help. Thx!
We are trying to extract the data from a [login to view URL] DB format. No one here has windows and we need the format in a standard Fix delimiter or BAR format. These are some of the files on the CD: .ISM .DAT .MAS They gave us [login to view URL] to access the file. These are the files in the dir: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view ...
...Every CSV Row written must be the xls file name ('Sample Freelancer [login to view URL]' in the example provided). All green values are csv column names (fields) and the grey cells are their corresponding values. Ignore 'Dropdown Lists' tab. Every time the PS Script is run, it should append to the existing csv files specified. PS Script will need to read
My challenge is that I have an engineering project that needs many different Word documents created to represent this project. All the data is in a single Excel spreadsheet, and this is the "master data". I have many Word document "starting templates" that need filling in. A word doc will be fully formatted as needed. It will already have the required
See the sample file. I need that everytime I run macro, it creates an output excel file as follows:- Each listing will be repated 11 times. What I need the in excel output is as follows: 1) From sample file Column B (Title) - Output File Column A (Title) 2) From sample file Column C (Description) - Output File Column B (Description) 3) From sample
We have images that are solid black PNG’s. We need a macro to run a batch of images Corel to convert the images to a solid solid white image. Do be considered for this job please let me know what day of the week it is.
merged locked and unlocked cells Require a macro copy and paste row with combination of locked, unlocked, single and merged cells. See attached..
...perform tests). The BMS design should be much of the basics, passive intelligent balancing, LVP and HVP that are handled by two external contactors. BMS will manage 4 or 8 LFP cells. But we also want some special features like; extra (second) LVP triggers with time delay, external power supply (12 or 24 V) and when off, there must be zero consumption (current)
...sheets what I want is to make a button that type all numbers that are connected to foumula to non formula cells for example: Name: [login to view URL] Views: 13 Size: 209.9 KB I want a button that when pressed all values that resulted from formula in cells (C33:K33) to be typed to (C2:K2) with no formula and can be removed when needed also I want it to affect
We import data from our support tool and this data contians Technician Name, Date and Time, Duration of call. Also, it ...Count of calls per day/month/year 4. I need to know what time of day we have heavy call volume. I need data per day/month/year. I want this report to be auto-generated in Excel using Macros. Sample Data can be provided on request.
...Tracking" tab, cells A22 and 23 should have a similar structure as mentioned above. The data for these cells are coming from the "sample Selection Rationale_Trac" tab. The data should be copied to the "Employee Tracking" in cells A22 and 23 in the following format: 21. Name of the FTE (taken from "Sample Selection Rationale_Trac" tab Ce...
I have a macro that scrapes a website in Chrome - and while it still runs, the macro previously would keep clicking a button on the site until more data was displayed. This is no longer working, and it is not finishing cleanly, it seems to be stuck in some loop when it should have finished. Small job, budget A$12
...complete this project. This project was previously posted and freelancer was unable to complete the work because of this. The Project: I am trying to find someone to build a macro within Outlook Customer Manager. When a custom button is clicked, I need it to create a series of tasks that are associated with that customers profile. I created two custom
Hi, Easy job of filling in an excel spreadsheet from a website. It's as easy as copy and paste. There are 700 lines to fill in (for each line there are 6 cells to fill in, meaning 6 copy and paste). Attached you will find the structure of the excel file.
Update a Google Spreadsheet with Data from an online report tool - 50 rows of information 30 cells per row.
I need a script making which will import a CSV into excel and then put the data into an easily readable, print format pick list in HTML. Check the attached file and take a good look a the first sheet. If you've actually looked at the document, read everything and have put a realistic, and informed bid, then start your proposal with the words 'No Placeholder'
Hello we are looking for devloper build one script open email and read message from spam folder and when he read message spam folder make it automatically to inbox folder and open all email folder account by account and each account have proxy should be open
Hello, We need to make Income Tax Return for the company registered in Gibraltar in Excel format. We are non-resident company for the taxes in Gibraltar. I will provide you with the following: 1. Our filled Income Tax Return for the previous year as a sample. 2. (a) Abridged Balance Sheet and (b) Bank Statement for the required period (1 year).
Put together about 15 excel files of email address Clean the list, like remove the name attached to the email address, Remove symbols ETC Cells contains a lot email address in it, divide them when marching togethier the lists put in coulmn 2 the name of origanle file
1. Connect the features in my theme to be working , all instructions are on article no codes required . 2. Make some dummy text spaces on other pages so we can enter the texts by ourselves when we re ready later .
...blood glucose ? Stress impacts your blood sugar levels. You're probably familiar with the body's fight-or-flight reaction to stress. When facing stress, your body allows your cells to access stored fat and sugars. Unfortunately, this mechanism can be more harmful than helpful in people with diabetes. This is because the release of stored sugars causes
To create an Excel Macro that would convert an Excel Table into a Word Table. I am attaching an example of the type table that would standardly be converted. The number of the columns would be fixed, however, the number of the rows can fluctuate. The rest of the framework will remain without change too. The resulting Word Table should be fully printable
...com/freelancer It is running a modified script, resources can be found here: [login to view URL] I would need someone to modify to add empty panels that will later change when the number of followers grow enough and also remove the commas. Included in the files is the custom script I am using along with what is expected
...internet as needed. Please look at the attached to be clear before bidding. I will supply an equivalent sheet with the actual names in to complete the task. You need to fill in all the cells in the two boxes. I have shown an example: as if I called two stores for the first retailer (and they gave me answers for two brands). If you bid, please tell me what
Project for connect ESP32 + 2 x 50Kg load cells + HX711 and little program code in Arduino to show working. Requires use zero factor for continuous load data. (In KG). Load cells are horizontally in front of box
...on internet. Please look at the attached to be clear before bidding. I will supply an equivalent sheet with the actual names in to complete the task. You need to fill in all the cells in the two boxes. I have shown an example: as if I called two stores for the first retailer (and they gave me answers for two brands). If you bid, please tell me what
Basically what I would like to develop would be an app to help people coming to the malls to have an access of information on how many parking lots are left and if possible to book them in advance
I need assistance with another Worksheet. The project involves editing information contained in an Excel Worksheet. There are 2 columns of text (2000 cells), and I need cells from column 2 to be moved and edited into column 1. This can be done via cut and paste or via formula(move cell B1 to A2, B2 to A3 etc). I will prepare the worksheet and provide
...([login to view URL]) A VB script macro is required to turn "on" the relay and another macro is required to turn "off" the relay. The macro file (.m1s) is executed upon a g code command as the software runs. The usb relay is on COM4. I need someone to write the 2 macro files ("on" & "off") Ref [login to view URL]
...A loading mechanism (a [login to view URL] webhook) currently loads receipt data from companies’ POS systems into my Google Sheet. * Google Sheets has a limitation of 5 million cells per sheet (estimated 3 years of receipt data for 1 company). * I must save receipt data for 5 years for each company per the regulations. * I am considering migrating to an
We are a startup IT consulting firm and looking for a excel macro which can be used for sending mass email using Gmail. This macro should allow us to send atleast 1000 emails at one shot. Excel should allow columns like first name , last name and email address
Looking for a Word Macro to extract contact information from a Word Document and save it in a IBM Lotus Notes database. Macro from Word to extract FirstName, LastName, Email, Phone Number, Job Title, if there is an address then Street Address, City, State, Zip and put those fields into an IBM Lotus Notes document into the respective fields. I will