...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 (except
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]
We are looking for someone to come in for one or two days to give a few employees intensive VBA training for use in excel. We would also look at using the same person to ongoing VBA programming support
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
Hi I want to automate my manual task daily and want an tool that will generate a report from database. This involves filtering of multiple tables and columns. I have created an sql script, but I dont want other people directly accessing db.
Exel VBA Have a good freelancer who helps me on a regular basis but needs more Have a small project Find the first week '17 ' (Sheeet ferieplan fields B4) see if “x” on Thursday 'T' field E6 If there is a “x” then open the sheet “17” and find employee Karina Line nr. 5 and 6 Paste “Ferie” inn cel...
I have a list of contacts in Excel. I need to be able to email the contact by pressing a button which will open up Outlook and pull the information from the active row into the email - like a mailmerge. This needs to be a button task as my users have limited IT knowledge. I have attached some screenshots to explain what I mean further. Thanks Dan
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
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)
I need a basic VBA program to analyze the data from each group of the files provided. Refer to the instructions for further details. This project should not take more than an hour or two to complete, especially if you are familiar with VBA (Excel).
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