Bot macro jobs
...se copien donde corresponde en Usados desde Retazos que es donde lo ingreso. Logré hacer una macro grabada, se aplicaba el filtro bien pero al momento de copiar el contenido que estaba ya filtrado siempre tomaba la fila con la que había programado la macro y no había forma de que tomara el contenido de la celda filtrada (que al momento de filtrar queda
I am looking to hire an excel expert, must be a VBA expert (no recording of macro as it will require you to write custom code). I will require you to make a template for me to import various balance sheets. I will share further details with the short listed freelancers. Please start your application with the word - "VBA EXPERT" so that I am aware that
We are looking for a Excel Sheet, where we will enter the product's component (fixed values), later it will 1. create the variants itself taking attributes itself and 2. Also calculate the total price itself. 3. Price will be based on the component. 3. Categories will be assigned to each variants. 4. Features once selected , will be copied to all variants. 5. Data in cell which are sa...
I have list of domain address. I need Company address & Contact number based on domain. Is it possible to do?
I need to develop a macro to control a Windows application to perform some automated tasks. The application is a cloud based messaging app and I do not own the app. I just need to macro some tasks to perform on the app. More details to follow when we talk privately. Some of the skills required: - Perform tasks in the app - repeating this
We will provide few input files. Macro should read content from the input files and prepare excel sheet in pre-defined formats. It should also run validation checks based on defined logic and flag if any error.
...se copien donde corresponde en Usados desde Retazos que es donde lo ingreso. Logré hacer una macro grabada, se aplicaba el filtro bien pero al momento de copiar el contenido que estaba ya filtrado siempre tomaba la fila con la que había programado la macro y no había forma de que tomara el contenido de la celda filtrada (que al momento de filtrar queda
Hi, i have two files here. Currently i have to go to mailing section in the ribbon. Then click load existing data, find the excel file and select the sheet. Can you automate the whole process, where the printing, will select data for all sheets in the excel file and print all of them out?
I need help to develop a macro to control an android app on an Android Emulator to perform some automated tasks. The android app is a ride sharing app, and I do not own the app. I just need to macro some tasks to perform on the app. More details to follow when we talk privately. Some of the skills required: - Perform tasks in the app - repeating
Currently, the excel VBA breaks down all the mailing address into groups of 30 in a sheet Errors in this macro: 1) The final sheet does not have "A" in column A first row, "B" in column B first row, "C" in column C first row with the entire row frozen 2) The sheet starts from Sheet 3 not Sheet 1 Please rectify
Button 1. UPDATE Button 2. UNDO UPDATE BUTTON, MACRO STEPS: Step 1. RESET > Clear all data in "Import sheet" and "Convert sheet" Step 2. IMPORT > Open the *.xls files in the source folders and copy the data and paste to Import sheet. There could be more xls files appending the data from the last data.
BOM =...is a document used that has details of all the raw materials that are needed in order to produce one unit of a finished good. In the Macro, we need each BOM to be in a particular format in one sheet only. The Macro helps us to create a BOM in a separate sheet for any one of the Raw Materials present in a parent BOM by the click of a button.
I need a Excel macro developer to work for me on my project Condition: Payment: Will be made after project ends. Budget: $25 Estimated time: 5-8 Hours depending on your skill TIme/Duration: Project needs to be completed in 2 days Maximum. If completed in one day then he will get a bonus of $5 Please start your Cover letter with " I READ AND
3 page "Summarize, Analyze, and React" paper on a macro topic, using at least 3 (good quality) sources.
A few years ago, a Freelancer made us a macro that would pull information from 2 different web sites. Over time, the websites changed and the macro code no longer matches the original fields. The result is that no information is pulled from either site. I've attached the old macro (an EXE file). When it was working, the EXE file was located in
I need someone to help with me a macro in excel. It's giving a simple error.
Existing xls with special character on the excel will be merge on specific header -
...help writing a Macro (VBA) in access that can populate (add data) into a table. The macro should add 1000 rows The columns are: 1. ID (just increase after each one) 2. Date1 random date between two dates is selected 3. Name random name from a set list. I don't want it done in excel or other software must be VBA access macro. to make it
I need a very simple export/save as button added to my excel file. 1.) The button needs to have a conditional format. When 2 numbers (cells S1 & S2 = each other the button is active, when said numbers do not equal each other button is deactivated. Button location is cell R4 (Where it says EXPORT). 2.) When this button is active and pressed it exports all worksheets within the excel file (...
Take an existing Excel spreadsheet, that is formulated with macros as an assessment with questions and multiple choice answers and add additional questions, answers and adjust the summary page to include additional areas to be assessed. and
...sample sheet will vary. Sample sheets are locked with password 'lb' Save sample sheet in a folder and master sheet in a different location. ON sheet1 of master execute the macro, and this collates data from sample1 and sample 2 sheets in a new tab on master sheet.. Changes required 1> Everytime when data gets collated in master sheet the new tab
1 Develop an Excel macro in this Excel workbook that compares the values between Sheet1 and Sheet2 2 Compare just the first column in Sheet1 to the first column in Sheet2 3 Create a new worksheet named Compare Result that shows the result of the comparison 4 If the Compare Result worksheet already exists then delete and create a new worksheet named
I have excel sheet that has line of data which need to be organized and then split to columns based on certain conditions till the end of the file. Exactly 13 columns. The conditions and sample text are in the attached xls sheet.
Need a macro or similar solution for google sheets which convert a short list of summed up products into a long list of single products. See example in link below. It need to work seamless so we just insert the data we need converted and then activate the macro to get the list we need. [url removed, login to view]
I have a client who currently uses a Macro enabled Excel Spreadsheet to draw up a Quote and a Job Sheet for a client. The system is now quite antiquated and we need to upgrade it. As the business has multiple employees who are quoting now, I would like to see if we could migrate this type of system into a PHP based system that would sit on their
Hello, I've a macro and I need to make one change to this macro in order to allow the macro to start from any line and not from a specific line
Hi, I am looking for someone who can write an Excel Macro following the instructions in the attached file. I will be more than happy to provide the excel file to serious inquiries. Feel free to ask questions, I will answer asap. Good bidding!
Vlookup of email addesses to identify non-duplicates Used for Norwegian excel setting Macro Purpose: To send invitation to newsletter customers that is not on the email list of the newsletter already. Add emails in an input column then run following macro procedure: Look up emails in another column ( currently 12000 emails) to see it there are any
Macro to looks for some data across files and then pwd protect it ex: open sub folders in the drive and look for word BND, if available inser collun in a excel and mention as Yes
I need an excel macro needed to fetch specific data from a popular source. Will provide more details through chat. I need someone to start immediately and will finish this in 2 to 3 hours. ** No escrow. Payment will be only after provide me the working macro fully. ** Maximum budget $15 (including freelancer fee)
We need a macro in excel which deletes an entire row, if two cells in a row show an outlier. Our problem is the following: in large data sets, it might be difficult to find outliers. Therefore, we need a macro. An outlier is defined by the difference between 2 data points. Therefore, the macro should be able to delete a row, if the difference between
i have xls generated by program, i wanted it open in excel file with group, sub totals and with nice design
Excel Macro to calculate selling value by FIFO method Create an excel Macro to analyze transactions and calculate the selling value of each asset using the FIFO method. Description: 1. “History” Worksheet –All transactions recorded by date. The macro should calculate the sell values of the asset according to FIFO method. 2. “Inventory” Wor...
Macro to looks for some data across files and then pwd protect it ex: open sub folders in the drive and look for word BND, if available inser collun in a excel and mention as Yes
Macro to looks for some data across files and then pwd protect it ex: open sub folders in the drive and look for word BND, if available inser collun in a excel and mention as Yes
I have dates in pivot , we need to change the filter(date) and save it as pdf automatically this should be done for almost 1000 times in one go.
A macro shall transform a table from one format into another. The table gives time intervals and further values assigned to these intervals. I am interested in converting the time intervals (calendar data) into a series, and assigning numeric values to these intervals in the series in a consecutive order. Attached is a sample structure that gives you
I have an Access macro to automatically import the information from each invoice to its respective table from xml files (Which you can see it attached). You will also find attached a file called CFDI example, which is an example of the xml files I need to import into my Access database. My budget is from 30 to 60 USD. I want you to modify the VBA code
See my example in my file. Sheet/tab 1 there is the datas that i will add and in sheet/tab 2 there is the transformed datas (add a button to run the macro in this sheet)
Create Macro to parse Spreadsheet We have an excel document with one column that has a field with many attributes in one. I need a macro to properly split these attributes into columns so i can import that in properly. You can see this column in the picture below . It has a specific structure. There are many attributes that are different for many
We have 8 to 10 forms created in excel 2003 which are macro forms and include Add-ins. When we open this forms in office 2010 / 2013, we are able to open the forms but the add-ins are not working in higher version. We need to make this working in office 2010 / 2013
I've created a macro that will take the data in sheet X and write the results to teams sheet. The criteria that is necessary that you can see in my code is the following: 1. Players can't repeat. There are 8 players on each team 2. Salary must be between 40,000 and 50,000 3. Each team must have one of each position (column C) but no more than 3 of
I have some work, in an Excel spreadsheet. Create a macro & set up 4 auto filters inside one workbook.
I want to get the best sequence that will utilize a 120" lineal to build a sequence of window sizes. All lineal come in a standard 120". For example, in the current sequence, I have a window height of 40", I will need a total of 80" for the height of the window. I want to be able to look for the next best sequence that will utilize the remaining 40" that is left from the f...
We have a few medium to complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: Our macro parses data (3K rows+), and based on several macros, splits the data into worksheets and then does some minimal vlookup functions and similar functions and updates files
I habe two excel file, one with summary fields and one witn data. Want to make the summary sheet a master template availavle to be used in multiple data files. Details - On the summary excel data sheet there should be button browse and pull data from a another excel csv file - Once the data is pulled to a new data sheet , this data sheet should up date numbefs from the summary. I can manual...
1. Install imacros extension (on chrome) [url removed, login to view] (macro script) 2. Login into WhatsApp web [url removed, login to view] 3. Visit WhatsApp scheduler [url removed, login to view] (you will be editing this script) PROCESS SEND 1. Enter a phone
This project to write 1 Excel Macro. This Macro will be run daily/weekly. The Macro will convert a 1 .CSV with data and 1 .XLXS that will be used as a lookup and convert the output to 1. CSV. The format of the two input files will always remain the same, format/template, however, the data in the file will always be different. Long-term work