Memerlukan satu format Excel untuk industry katering dimana recepies & senarai harga barang barang telah di daftar & boleh di tukar. Pengguna hanya perlu mengisi jumlah pelangan & menu pilihan termasuk inventory semasa untuk mengetahui banyak mana barang mentah perlu diorder. Hanya untuk Malaysian
...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 other things: Filter data on a prespecified
...company that needs to create a system to track service 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 con...
Need a local Developer located in Wisconsin. Merging Order and Product Data...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...
...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, organ...
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)
Hi everyone i am after a pricing solution for my shop. It is a tyre shop and tyres have many brands and many models in each brand and thousands of different sizes in each model and each brand. I need a solution where 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
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.
...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 ...
I'm creating a raffle drawing. I have participants purchasing multiple tickets but they are rolled up into a single cell. I would like that cell to duplicate the names by the number of tickets purchased. Similar to this....[log masuk untuk melihat 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 bu...
We have a small non-profit HOA (9 units) ...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.
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
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: [log...
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.
I need to come up with a process for conducting a billing audit. I exported data from investment 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)
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...
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 [log masuk untuk melihat URL] XO8zV6htH_Hi5646VV5g&sa=X&ved=2ahUKEwjbtIu61Y7fAhUE_KQKHcoMBqsQ9QEwAnoECAMQCA#imgdii=c_
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 t...
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 bal...
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.
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
Require a spread sheet that can calculate a daily average, for ...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.
I have 13 Sheets and 1 Sheet Master. If in wichever 13 Sheets in column B i check "x", then in column A allocate a unique number automatically. If this number is already in Master, msg box " the number exist", and delete number. All data from A:Z copy to master
It is a one time project. I want to make a excel invoice template, where there are some basic calculations, that should be automated. Once ready, I should be able to create invoice, save. If possible, invoice numbering to be AUTOMATED, from the number I put first.
I would like an expert to do a series of excel sheets for my Air Conditioning System Quoting, different brands, discounts, finance rates etc to be worked into quote forms and the ability to save as a pdf to send to customers with relevant info only. Sample of my current one I am using is attached as a photo
I work as a public hospital radiologist and report on both private and public patients. Im paid hourly for public work, and need to make a deduction from hours billed each day, depending on time spent on private patients. Every month i get a spreadsheet with the private patients which ive reported on for each day, and i need to total them up, allocating