Salutare ! As avea nevoie de ajutor legat de un proiect pe care il am in desfasurare. Am o data de baza cu niste piese la care urmaresc views-urile din anumite grupe. Momentan folosesc un sistem mai rudimentar, fiecare categorie are culoarea ei, singura problema este ca dupa un anumit timp nu mai ai culori din care sa alegi. Ar avea cineva o solutie mai practica ? Am citit pe forumuri ca ...
Dear, We have a large data project with data that is structered in the same way in each excel file. We would need a relatively simple macro to do several things automatically. We want to compare averages and test for statistical significance. We provide the formulas and illustrate clearly what has to be created. The macro should be able to do among
...visits to customers. We have the data (dates and customer names, report author) that can be exported to excel from the online program that we use. This data isn't displayed in the format that we want. Ideally, this data would be exported to excel once a month, and then somehow converted to a more readable format. We are looking to add more information
Need a local Developer located in Wisconsin. Merging Order and Product Data from our Web Site into vibrant spreadsheets that allow logistics scheduling, auto completes various forms, incorporates individual state pricing, ability to manipulate orders vs available inventory and brewing schedules. Beer Industry knowledge a plus.
I do have an excel question if you do not mind helping me, it is for my work. I am working on a spreadsheet where I have to take for example: If cell G:G="3020" & cell J:J="Credit" then copy the number in Cell K into another worksheet or workbook. I tried doing a IFANDTHEN formula but could not get it to work, I also tried a combination of formulas
Needs to hire 9 Freelancers Microsoft is looking for several translators with expert mastery in Word, Excel and PowerPoint products to help localize 3 simple templates (one of each: Word, Excel and PPT), 1 complex template (Excel) and the metadata file that goes along with them into the 9 languages below. The freelancer will be provided with English
I'm looking for an Excel expert to do a few things to my spreadsheet, and to explain to me how you did it (so I can learn). Note: I use Excel for Mac (version 16.6.7) I have a large Excel file (~7 mbs, ~74,000 rows). The file contains many different web page URLs, along with SEO metrics (e.g. domain rating, organic traffic, etc) for each URL. I
Open a web page Enter data from excel cell A1 Hit the Submit button Capture the text from the web page and copy it in cell B1 Create a loop to repeat this process 1000 times from A1 to A1000 For each new entry the same page is required to be refreshed The interval between 2 entries needs to be random number (1-5 sec)
...i can just search for a tyre size (Width / Profile / Rim Size) and i will have all the tyres i have in that size filtered in front of me. All my suppliers provide me their excel spreadsheets with pricing and i want to be able to manually update the spreadsheets whenever i want (in other words change pricing whenever i want for particular models of tyres)
I am doing a University project on excel and I am struggling to transfer the means test and means training for each participant. I just need help in explaining to me how to do it but to do it as well. I will provide last years data set but the format is slightly different.
Please see the attached file. I have a large database with 1500 rows example on sheet 2 and i would like to be able to select a row and see the data displayed on one sheet something like sheet 1. i need to be able to make changes to the data in the format of sheet 1 and this changes the data in the main sheet. Im not sure if it is best to create a second sheet and the data can be mirrored and edi...
I'm creating a raffle drawing. I have participants purchasing multiple tickets but they are rolled up into a single cell. I would...rolled up into a single cell. I would like that cell to duplicate the names by the number of tickets purchased. Similar to this....[conectează-te pentru a consulta linkul URL]
This is for a company dealing in custom-fit curtains. Want to create a template for various shop owners wherein they type in the data needed for customised curtains and a simple formula provides instant quotations and data. However, it needs to look well designed and neat. Can explain more in detail.
I work for A-OK heating & Cooling we're needing someone to create a pricing calculator for use i've started crafting a excel workbook but its a little difficult for me. Basically all I will Need from you is formula entry I'll have everything else formatted and input before you start. i'm attaching my current draft, its not ready completely yet but it
We have a small non-profit HOA (9 units) and a very simple spreadsheet. We would like a spreadsheet that automatically creates a monthly budget and yearly budget as well as keeps track of the expenses and income/dues/assessments. We would also like the ability to securely link to the bank account and tax forms.
I have a list of roughly 317 dates, most of them are already completed..... I need the date range separated for the cells that have back to back date ranges such as "17-18 Aug" into two cells "08/17/19" and "08/18/19". All cells should be formatted the same with the respected dates.
I am consulting to a company that wants to monitor stationary and equipment ordering, distribution and re-ordering.
Questionnaire in an excel spreadsheet. Was 10 questions, I cut it back to 5 questions. Now the spider diagram on the Full Report tab doesn't work properly. I need some one to do a thorough clean up of the mess I've made :-). Also want the spider diagram to be fixed scale out of 10, i.e. not shrink when there are no 10s.
My company is looking to hire a PROFESSIONAL AMAZON Sourcing expert for our Online Arbitrage business. Requirements: 1. MUST be knowledgeable about Amazon. 2. Must have or be able to create Amazon account. 3. Must have general accounting knowledge. HIRING PROCESS: First, we will interview individuals on a TRIAL run bases to see if they can follow
ADVANCED EXCEL VBA PROJECT - Macro Experts Apply REQUEST FOR YOUR PROPOSAL: Introduction: We are looking for an Expert Excel VBA automation specialist for our project. Deadline: We would like this entire project fully delivered and tested within the next 7-10 days MAX. Our Project Requirements: *** AFTER YOU REPLY TO OUR 13 Questions We Will
Expert EXCEL VBA Developer Needed ASAP - Work From Home Want to Work from home on Various Exciting and Challenging Projects? We are seeking to hire a Team member who has an EXPERT STATUS in ALL these following areas: • Expert in VBA Application Development in Excel; • Expert in All Excel Functions and Formulas; • ...
I type in pictures into an excel file for our auction business. Here's what I need as you reference the document attached: I receive from someone else a range of numbers (Example: 45-51) and I have to type them in to end up like the following with a space in between each number after the .jpg It would like this: [conectează-te pentru a consulta linkul URL] [conectează-te pentru ...
I have an excel sheet I use for payroll. I need it to add and subtract totals. I have attached an example of what I need. the problem would start with the Wage times the number of hours. and it would add as I input the number information. Minus the loan payments.
...advisor software showing all accounts that were sent an invoice (columns A-D). I then exported data from from the software showing all accounts that had a management fee transaction, proving that the fee was in fact deducted from the account (columns F-I). As you can see, 34 accounts were sent an invoice but only 32 accounts had the fee deducted.
Need someone to help me write some excel formula - 1) identify and record maximum and minimum of dynamically changing value in a cell. Along with recording just the maximum and minimum value, requirement is to also capture value of the another cell from same row, to identify the maximum and minimum value for a particular parameter, as well as time
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There a...
Crear una macro que genere un archivo plano para pago en bancos, que imprima y envíe por correo los soportes del pago a realizar a cada tercero (pueden ser varios pagos al mismo tercero y necesitarían relacionarse en ese solo reporte), y que al final imprima un informe con la relación de pago del día detallando la cuenta desde donde se giró, los valores de cada f...
We have data with us and for our group project we want to show data, something like this [conectează-te pentru a consulta linkul URL] XO8zV6htH_Hi5646VV5g&sa=X&ved=2ahUKEwjbtIu61Y7fAhUE_KQKHcoMBqsQ9QEwAnoECAMQCA#imgdii=c_SZknRpnN4D0M:&imgrc=nAxYXNryCVoW-M: We have data in this format [conectează-te pentru a consulta linkul URL]: we compared 3 websites and get emotional responses, w...
I need someone to add either a formula or a vba (that I can edit later) which will take information from sheet 1 and automatically transfer it to various other sheets. I need it to do this based on the zip code in the address. Example would be 60 different zip codes around me - however, only 13 will go to sheet 1, 27 will go to sheet two 10 will go to sheet three and so on. I need a formula or v...
I am building an Excel Template for use in my business. The template is used to control purchasing to budgets. I need a Data Entry Form created to aid easy input of data on a daily basis. I want to measure purchasing against Budget and show available Budget for spending. As purchases are made, the data entry will calculate the MTD balance.
We would like to put the excel spreadsheet attached and embed into our website as a cool calculator tool for our clients.
Microsoft excel project. In this project you will complete a vehicle shopping workbook to compare the purchase of several vehicles. After completing the project, you can make a copy of the file and use it to compare vehicle purchases you are considering for yourself.
...We are looking to hire an absolute expert with PHP to take over our existing PHP app. We found a few bugs that need to be fixed and also want to add new features. Very lightweight php system we have, any expert can handle this. Some of the features we will need to add: - update to latest Google Map API - Add export to Excel function - Filter
I have an excel spreadsheet that I download monthly, would like a macro or something if possible that will - Separate into different groups, then total up those groups. Currently, I am sorting into groups then writing a formula for each group. Each group, the amount within that group can change, one month it could be 50, the next month could be
It's an 8 x 14 (legal sized) document that gets shrunk every time I go to print. I'd like to keep the same exact information, all on one page but with infinitely smaller margins so the text is not as tiny which makes it hard to read.
We need somebody to create macros and formulas to convert incoming excel order sheets to a readable excel sheet for our System. This includes pulling the needed data from the existing sheet and partially converting it to our format
We are a real estate brokerage in need of a dynamic spreadsheet for our agents. The spreadsheet will reverse engineer how many deals are needed to get to gross income > net income. The agent will be able to change average sale price, commission and desired net income. There will also be a separate calculation for all deals greater than 50 nested within the spreadsheet that is dependant on the v...
Require a spread sheet that can calculate a daily average, for the period, since the last meter reading, but calculated from irregular date data collection, of running total from a use meter. Would also like the data plotted as a graph showing the average over total time. Attached is some explanitory details.
1. Formula for Markup 2. Formula for Volume Pricing A. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet. I (amatear) have used (If) formula, I know you can do better. B. I have try to have volume discount formula and failed. I use hidden columns. I use Teamviewer.