Create A Spreadsheet That Will Automatically Increase The Work Order Number By 1?
Jun 20, 2014
I am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.
The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.
I am using Excel to produce work orders and I need each one to have its own unique number. Much like an invoice or contract number, each time I open the file I would like Excel to generate a new number for that spreadsheet with a value of 1 more than the previous spreadsheet.
I'm creating an order form in excel. I would like to add a control there where when it's triggered, excel would automatically assign a number that hasn't been used before and save the file using that number. It's like an order number generator.
For example, let's assume I'm entering a purchase order in excel. After I'm done doing that, I click on the "SAVE" control button. This will assign the number following the last saved order and save the file in a location I specify in this format: filename POnumber.
I've got a master spreadsheet grabbing data from 12-13 different tabs/spreadsheets.
One of those has a table, and I was wondering:
Is it possible for the master spreadsheet to automatically add a new line every time someone adds a new line and creates a new entry in a different spreadsheet?
In other words,
If there is a table in the master spreadsheet, and someone adds a new line, is there a formula which allows the master spreadsheet to add a new line in order to autopopulate?
We want to create an excel spreadsheet that will tally the number of votes for a particular artist's work. There will be about 150 artist's works that will all be assigned an individual number from 1 to 150 on an excel sheet.
We will have about an hour to complete the counts to determine winners, so a short time frame.
Is there a way of creating a formula/macro in one cell -to just enter the number of the artist's work that was voted for- and have it placed as a tally against the individual piece?
I’m getting data from query. My data has fields: Item No, Customer ID & Sales rep. I need to find out for each Item number which customer put order and who was the sales rep. (Excel 2002). see file attached.
i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.
What i'm looking to do is create a spreadsheet where the first page allows me to input the number of teams in the group.The teams cannot play others in the group except the ones they are paired with. eg. "Enter number of team pairs in set" (in this case 4)
Team 1a vs Team 1b Team 2a vs Team 2b Team 3a vs Team 3b Team 4a vs Team 4b
After number of teams in set is established click a start button on the first tab of the spreadsheet.
this auto generates a new tab with all the possible win/loss combinations of 4 team pairs.
New Picture.jpg
if the number of teams on Tab 1 is changed (say to 6) and the start button is clicked, another new tab is generated with all possible win loss combinations of a 6 team set.
remember 1a vs 1b can only be win or lose and the win lose combinations are for the set of 4 matches ( or more matches if specified on the first tab and clicked).
if you put 7 in for the number of team pairs then it would be win loss combos for 7 pairs of teams.
How to increase & decrease numbers evenly for a spreadsheet.
I have a number in cell F16 that can be changed and for this example say it has a value of 900. I have a number in cell F17 that is always more than cell F16, for this example lets say it is 1000.
What I'm trying to do is create 10 numbers evenly increasing away from 900 (F16) in value, & 10 numbers evenly decreasing in value away from 900 (Cell F16) but here's the catch.
What makes this tricky is that the numbers that are increasing in value away from 900 (F16) can't be bigger than the value of F17 , IE in this example the number 1000
So the formulas must evenly distribute 10 numbers BETWEEN 900 & 1000. This must have the same even distribution for the increasing numbers & decreasing numbers.
I'll attach a sheet also. So, if you say 900 is a starting point & 1000 is the ending point, what formulas would you need in each cell to evenly increase to 1000?
Also,, going the other way, decreasing, away from 900 at the same rate as the increase?
Really stuck n this 1. Spreadsheet here: [URL] ...... Screenshot here: [URL] ......
I would like to create a financial modeling spreadsheet. Basically my problem is this; I want to have a month by month row for 5 years. For the value of each one I would like it to increase by 950 per month automatically.
I have a range (M6:BM6) which consists of week end dates = every Friday (M6 = 5/8/09; BM=5/7/10). I would like to have the range adjusted based on when a cell (B3) is updated. For example, currently B3=5/5/09 and M6=5/8/09 (week end date of B3). If B3 was updated to 5/12, I would like to have the range automatically updated to M6=5/15/09, N6=5/22/09....BM=5/14/10. I could do this with excel formulas in the sheet but would like to macro code adjust the values in the range rather than formulas.
These ranges are used in other macros and works better with values rather than formulas.
I have been playing around with some data and can't seem to get it the way I want it. I have played around with Pivot tables and grouping but I can't seem to figure out how to accomplish what I need in Excel. To better explain I have attached some test data of what I am trying to accomplish.
It is data for a time study to compute labor hours. I have managed to group everything together per "work order" and "Employee ID". I am trying to sum up the labor hours by work order. I know it sounds simple but I do have another question. Once the total hours are set. Are they still available in the same format when put in a Pivot Table?
The spreadsheet has been around for a long time. Even in the electronic form, it has been around for over a quarter century. How has the electronic spreadsheet improved or changed your job?
I'm taking a course in computer applications and will be using any information I get in replies to this thread in my term paper.
the form works fine and is loading the data to the spreadsheet and inserting it into the first empty row. I need to reverse the order of entry into the spreadsheet. So instead of the data from the form going into the first empty row down the spreadsheet, I need to insert the data in a common fixed row at the top of the sheet, every time and then shift the older data out of the row and down the sheet. Essentially putting the oldest data at the bottom and the newest at the top, which is reverse of the EROW entry process, Last row command would essentially do the same thing and I don't know what command would do what I want.
I am building Food Stand Orders Record Table, which I would like to automate and reduce the data entry process as much as possible so that it will take as long to enter all 400 orders into the spreadsheet and mitigate errors and calculate totals. I am looking for ideas as to how to make this easier to update. Also, I am not set on the concept of the spreadsheet, if there is a better way to capture this data.
Below is a list of columns in my Order Record Spreadsheet: My spreadsheet start on A5. The Header row is A5:N5
No. = record input number Order # = The number of the order taken (i.e. 35306 – 11, 35306 – 12) Item = The Items sold from each order # Item Category = Was the item sold a special order or standard order Date = The date the items and orders were sold Time = The time the order was taken Quantity = how many of the item was sold for that order # Order Taker = record of who (order taker) took the order # Item Price = What is the price of one unit x the quantity of the item sold Total Order = What is the total cost of each item price associated with the same order # Cash Received = We only accept cash, what was the cash tendered with the order# Change = What is the change amount given to back to the customer associated with the order # Donation Received = Is the change amount, When customer associated with order# did not accept the Change. Notes = special notes related to the order#
what i need is a macro to run when I print a form. I am making a job card with a unique number on it ie: 100. when I print the form, I then need the 100 to change to 101 and so on. I cant work this one out.
EDIT - Ive attached my work in progress. It is for a computer repair shop. I have a few macros in there as I need to email a copy of the workbook too.
when you open the workbook, you will see the job number in red. I just need a macro tht will increase that number +1 every time it runs. I also need the email macro to rename the workbook to the customer name input in cell B4 - but I think im best to post this request in a new thread?
I have a worksheet with data in several rows. Column wise they consist of names, points etc..
I am trying to setup a formula whereby the formula looks at the data in the points columns and then re-orders the rows accordingly taking all the information in the row with it, with the highest points total at the top and lowest points total at the bottom.
Each points cell, has a formula in there already which pulls the points total from other cells and combines them.
Problem: I have textbox entries that are part of a Userform that opens using a macro on a speadsheet button. Once this form is open, I can no longer actively work in the spreadsheets.
Need: I need a way to minimize or "put on hold" the Userform so that I can freely move around in the spreadsheet. This could be in the form of a button on the Userform. Then, I need a way to bring back this userform to the point I was at before being put on hold so that I can continue to input entries into the textboxes (again, a buttton that could bring it back). There should be a way to toggle between both worlds.
I have a large order spreadsheet with 3 date related columns. One for customer requested delivery date, one for factory quoted delivery date and one for actual delivery date.
I want to be able to set something up that if it gets near either the requested or quoted delivery date (by say a week), that the cell flags red so it's a visual reminder to check whether the order has been dispatched etc.
In column "A1" i have the formula =C8. I now need to copy this formula across to column "B1" to get =C9 and also copy it across to column "C1" to read =C10.
So the row number should be increasing by 1 and the column remanin constant.
