I have an upholstery business and I have created a workbook containing multiple sheets (proposal, invoice, sales order log, etc.. ) Following, I have saved it in Template format, which I open and save by order number somewhere else. The issue is, I don't know how to track what the last order number I used was....
Is there anything I can work using excel that will allow me to make that easier without having to go open a window and looking at the last order number after arranging the workbooks by name inside a folder?
In the toolbar there's a section titled "Number" which allows you to change cell formats with selections named General, Number, Accounting, Date, Time, etc. I want to permanently change some of their default formats.
For instance, currently when I select Number the default is -4000.00. I want to PERMANENTLY change its default to (4,000.00). How do I do this?
I've created a spreadsheet containing 200+ entries for my companies suppliers. These include their name/code, contact emails and contact number. This list is far more easily accessible as it saves the user having to bring up the suppliers details within our own bespoke software. However what seemed like a nifty spreadsheet has quickly turned into a giant mush of details with no way to quickly find the one you want without scrolling down to the one you want.create a function/tool that can allow me to type the contact name in cell "X" and have Excel take me to the suppliers line in the table?
Is there any excel-addin which offers function in which you could search any excel function (not just formula) so that you could access any function in a seconds, just like google desktop search for windows.
Right now you could use quick access for most common functions you use and shortcuts for functions in different group. But if there is universal search for all the functions, it is going to be faster for any access!
I have a 'dashboard' worksheet in 2010 and want to be able to click on a cell in this sheet and have it take me to the assigned worksheet. They are all in the same workbook. e.g if i click on Leadership i want it to take me to the Leadership tab, Skills to take me to the Skills tab etc The 'dashboard' will be the only viewable sheet in the workbook until one of the items on the page has been clicked.
I have a very basic understanding of macros and I'm not sure if this would work or if i should use a formula instead?
In Excel 2010, I used the camera tool to take a snapshot of a selction of cells. How do I save the snapshot only as a JPG or GIF file?
I know that there are programs outside of Excel that can take snapshots or print screens, but I need to accomplish it using the camera tool so the snapshot is the exact selection everytime. Is the excel snapshot temporarily saved somewhere on my computer where I can access it?
I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)
Problem Example.png
.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.
I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.
But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.
Instead When I press F9, I wanted the below to happen
1. Content from the Clipboard should be cleared
2. Take the screen print
3. Paste it in the word document.
Note: My tool/code already does 2 and 3. Looking for 1 alone, ,
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.
Essentially, the formula/solution will "know" that the third occurence in the list is actually the 3rd occurence, and so forth... I tried COUNTIF but that just gave me the total number of occurences
We have list for entries that is shared among few people. In that list, we manually add number for the entry. So if I input 99 then, next person should add 100 and so on. I would like to automize this, so say If I use this, then no one else can use it in the mean time and then when number is input, it should disallow if same number is input and it should automatically enter the next number.
I'd like to take the value from one cel, and reverse the digit order in another cell. Example cell c11 value is 1234, I want to display that value in cell c12 as 4321. Is there a way to do this?
i would like to rank a column so that when entering a number in a cell it will move up the column so that the greater number falls down the colum and the larger rises up the column
I am trying to develop an invoicing system for my company. Most of our customers will have their invoices formatted a certain way which has been relatively easy to solve, however one customer needs to have their invoices formatted in a special way.I have a sheet that pulls in a list formatted like this:
Date product order number kilos 07/4/14 48% cream 445600 1000 07/4/14 PHM 445600 1500 07/4/14 PHM 445600 1000 07/4/14 PHM 445600 2000 10/4/14 48% cream 445800 500
What I need it to display is the following:
Date Product order number kilos 07/4/14 48% cream 445600 1000 10/4/14 48% cream 445800 500 07/4/14 PHM 445600 4500
So you can see it is grouping the invoice by both product type and order number but grouping by product.
I have a first & last name with a number in cell B2 which looks like the following;
939 Smith, Silvia
I would like to drop the numbers and just return 'Silvia Smith'.
I have the following part of the formula to drop the number and it works. =RIGHT(B2,LEN(B2)-FIND(" ",B2)) Need to know how to layer in the other part of the formula to switch first and last name.
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 found the code below on the Microsoft website and it works except it didn't treat the worksheet tabs as numbers so the sort is 1, 10, 100, 101 etc.
How can I get it to treat the worksheet values like numbers and sort accordingly?.
Code:
Sub Sort_Active_Book() Dim i As Integer Dim j As Integer Dim iAnswer As VbMsgBoxResult ' ' Prompt the user as which direction they wish to ' sort the worksheets. '
[Code]....
' If the answer is No, then sort in descending order. ' ElseIf iAnswer = vbNo Then If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then Sheets(j).Move After:=Sheets(j + 1) End If End If Next j Next i End Sub
i have a list of part numbers that all have prefixes and i need to sort them into regular part number order and can't seem to figure out why i'm having such a hard time. the order i need them is this example. i need after part number 1-1 to be 1-2 followed by 1-3 etc. not 1-10 followed by 1-100. i hope i'm explaining this correctly.
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’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 am looking for a formula to number rows in A1:A500 I would like to skip a row when B1:B500 cells are empty then skip that row and start renumbering from 1 This is what I tried so far =If(b9>"", countif($B$9:$B9,">"""),"")
1. first I export data and directly paste in the "RAWDATA" Sheet. 2.There are 50 columns and each has header like Clientname,date,Id,campaign,websitename,frequecncy etc. 3.Exported data does not have same order 4.so when I paste data in excel I check manually if orders are in correct or not?which takes my long time to review/manually check
Using macro or something else to review the order and if any discrepancy then raise error? Need Excel to check order of columns ?
Using Excel 2013. I have a pivot chart with date as the x-axis, 1 y-axis series on a Primary and 1 series on a secondary axis. My pivot table is sorted in descending order by date because I need the most recent date on top. To chart the date in order from left to right, I've turned on Categories in Reverse Order .
1. When hovering over the data points on the primary series, the date is reversed. Example: the data point Jan31 says Jan1. 2. The bigger problem is the series using the Secondary Axis is plotting Jan31-Jan1 instead of the Reverse Order .
Is this a problem with Excel or is there other options that I can try to correct all this?
I looked at threads realted to printing but wasn ot able to find something similar to what I need. So here is my problem:
I have a file with more than 100 worksheets (each sheet contains the invoice for one store). I would like to create a macro that would enable me to determine the order in which worksheets would be printed. How to do it?
Idea #1: the printing order would be based on the value in cell L1 that would contain the route number for each store. Stores belonging to the same delivery route will have the same value in L1. So, the macro should first print all sheets with 1 in cell L1, then print all sheets with 2 in cell L1 and so on...
Idea #2: Creating a separate data sheet with the list of all stores and their corresponding route number. Let's say info is contained in range A1:B150, where Column A contains the name of the stores and column B contains the route numbers. The macro then should look at that list to determine the printing order of the subsequent worksheets (the name of the store in column A would be the same as the name of the worksheet corresponding to that store).
Idea #3: sorting my 150 worksheets manually. It does not solve my problem fully, though, because stores do not always belong to the same route. So the manual sorting should be carried out daily and would not save time at all.
