Order Sheet / PO

Dec 16, 2006

I have a master order sheet with 100's of items on it which I use to go through my stock room and enter the qty's I would need to order. I have then created a seperate sheet that I use as a P/O to my supplier, this picks up all the info from my order sheet. everything works well except when I do NOT need a paticilaur item. On the P/O it still shows but with 0 qty, I would rather it not show at all and move on to the next item that does have a QTY.

View 9 Replies


Sales Order Sheet

Feb 13, 2009

I want is for the the cover sheet to provide a simplified version of the price list for people to use that will auto complete price to customer once product has been selected.

- how do I create a sublist? so if a user selects a product group from a drop down list in cell b1 then cell b2 will automatically display only the items from that groups subset.

- how do I link prices? If a user selects data from a drop down menu in b2, is it possible to display the price for that item in cell b3?

View 4 Replies View Related

Sheet To Auto Sum There Order With Functions

Aug 8, 2009

i have a works order form with 6 peoples names on. when they make a order i would like my sheet to auto sum there order. so i can see how much each person has spent. i have attached a sample.

View 3 Replies View Related

2007 Order Of Sheet Calculation

Nov 14, 2009

What is the best way to name / order worksheets in a workbook to improve load / calculation speed?

View 13 Replies View Related

Code To Insert Rows In Next Sheet In Order Of Column B?

Apr 24, 2014

The below code used to work for me perfectly but in the last couple days it's been acting up. The code is supposed to cut out 2 rows from sheet1 and insert it in order of column B in sheet2. Up until a few days ago the code was inserting the 2, cut, rows properly but now it inserts it at the top of the sheet.

Here is the workbook I'm working with TEST.xlsm

View 1 Replies View Related

Fix Sheet Order So Code References Correct Sheets

Sep 14, 2007

I would like to know whether its possible to fix a sheet to always be the second sheet in a work book no matter how many other sheets are added. Currently I have set up macros to add subsequent sheets before the last sheet, so that Sheets("Number 2") remain sheets(2). Is there some way I can lock the first two sheets so that when I reference them in my code as sheets(1) and sheets(2) it will reference the right sheets. Right now I have it set up so that Sheets("Number 2") can be renamed by the user, and data inputted on this sheet, but I require that the user not be able to move this sheet and the sheet preceding it.

View 5 Replies View Related

Copy Determined Columns From Source To Destination Sheet In Particular Order

Oct 27, 2011

I have a source data sheet that has around 50 columns. I want to copy and past selected columns to a destination sheet.

View 1 Replies View Related

Macro To Set The Order In Which Worksheets Should Be Printed (order Is Changing Daily)

Nov 29, 2008

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.

View 9 Replies View Related

Re-Order Columns Based On Column Order Of Another Worksheet

Mar 1, 2008

I need a way to re-order an excel worksheets columns based on another worksheet.

Data is extracted from a database into excel however users can configure the columns in the initial system. to how they like This causes problems when the data is copied into an excel spreadsheet I have created as the data copied will not be in the same column order as is required.

How can i reorder the columns without physically having to cut and paste the columns to match?

I have attached a sample spreadsheet.

You will see on the spreadsheet that 'fixed columns' is the order that i require the data however 'variable columns' is not in the same order.

View 3 Replies View Related

Sales Summary Sheet - Consolidate All Data In Sales Order Number Wise

Jan 5, 2012

I have an excel sheet which has 70 sheets in it...All of them are numbered but not in a sequential manner (eg : 210,211,201,202,215 etc..).The numbering is nothing but the sales order number....

All the sheets have same data (i.e Column A contains Product Sold, Column B contains Sale Value)...The thing is i want to consolidate all the data in sales order number wise. i.e.

Column A Column B
201 $200
202 $300
203 $450

View 8 Replies View Related

Stock Order Sheet To Be Created From Stock Inventory

Jan 8, 2014

I have created a stock sheet on Sheet1, i have say 100 items and each item has a min and max stock order. Once the item hits a min low, the last cell (O) will display an order needs to be placed.

I was wondering if there way a way that on sheet2, it can calculate all the data on sheet1 and if there is stock that needs to be ordered, it will appear on sheet2?

This way i can just print sheet2 and send it to the supplier without having the entire 100 items displayed -if it does not need to be ordered?

View 7 Replies View Related

Tab Order In Forms

Jun 11, 2008

I would have like a chance to be able to remove the apparent potenitial dangerous problem from the thread below and not close it after 10 mins. I'm not on the site permenantly and keep dipping back in eveynow and again. I dont know what the issue is as when I open the file up I dont get any error messages. I have tried this on my machine using Office 2003 and Vista also another PC using Office 2003 and XP


The only error I get is a message saying Disk or Network error, when testing it on the XP Machine this is because doesnt have access to the Database it sends the data to.

View 9 Replies View Related

How To Know In Which Order It Is Sorted

Mar 29, 2009

When it is sorted by ascending and next time when they click header I want it to be sorted by descending.

Right now I have implemented to sort Descending . Now how will I check in which order does it sorted?

If know the order in which it is sorted currently then I will sort it in the opposite way..

View 6 Replies View Related

VBA And Getting Order Right For A Loop?

Dec 22, 2011

Here's what I would like to be able to do

1. On Sheet1 - do things (I can code that bit)

2. On Sheet2 - do more things (I can code that bit)

3. Create copies of both sheets 1 and 2 (to make Sheets 3 and 4) - can't do!

4. Repeat step 3 above 125 times to make 250 sheets (each being a 'clone' of sheets 1 and 2) - also can't do

View 2 Replies View Related

Duplicates In No Order

May 16, 2013

I'm trying to find 4 digit duplicate in any order from 0-9 in 4 different columns and because they are from 0-9 in each column it doesn't seem possible.

View 2 Replies View Related

Reversing Name Order

Dec 11, 2006

Can i take a name that is in "normal" order and change it so that it is in the format of "Lastname, Firstname Middlename" regardless of how many names are represented?

I have used a simple concatenate formula along with some left/right formulas to get this working if every single person in the list has only their first and last name, but I get errors if the person has 3 or more names listed.

So what I want, is a formula that will turn these names:

Carl Johnson
Carl Robert Johnson
Carl Joseph Robert Johnson

into these names:

Johnson, Carl
Johnson, Carl Robert
Johnson, Carl Joseph Robert

View 7 Replies View Related

Order Form

May 1, 2007

I have a list of some 200 odd items on one sheet that is my price list; what I would like to do is have another person - who may only have very basic, or virtually no excel skills at all, be able to select items from the price list and have each of those items go to the top of an order form on another page.

It needs to be automatic, and anybody that has only basic excel should be able to use it.

View 9 Replies View Related

Sort - How Can I Order Then In B1:B60

Aug 2, 2007

i have A1:A60 filled with numbers. however, they are ordered incorrectly. how can i order then in B1:B60 in the following way?

1st cell
7th cell
13th cell
19th cell
25th cell
31st cell
37th cell
43rd cell
49th cell
55th cell
2nd cell
8th cell
14th cell
20th cell
26th cell
32nd cell
44th cell
50th cell
56th cell


until the 60th cell

View 9 Replies View Related

Tab Order In Userform

Dec 22, 2008

I have several checkbox and adjacent to it there is a textbox. Also I have a command button.
On Form initialize, all checkbox and textbox are hidden, except first check box and textbox.
The first checkbox1 is enabled and textbox1 is empty. On Exit event of textbox1, the checkbox2 and textbox2 gets visible, with checkbox2 enabled.

On exit event of textbox1, the cursor goes to command button on Tab
My requirement:
The cursor should go to textbox2.

Note:- I have Tabindex set to as following:
Textbox1 = 0
Textbox2 = 1
Commandbutton1 = 2

View 9 Replies View Related

Paste In Order

Mar 3, 2009

I need a macro that will copy a row from Sheet1 and paste it in sheet2 but the row must be inserted in ascending order based on the enties in sheet2. The order in sheet2 should follow colums A, B & C

View 9 Replies View Related

List In Order.

Apr 30, 2009

I need to have 6 rows automatically adjust themselves, and be listed in descending order, according to a percentage that will change daily.

View 9 Replies View Related

Cells Tab Order VBA

Aug 9, 2006

The tab order in an Excel spreadsheet is driving me nuts. I could not get it on my own and found some code that seemed to solve my initial problem.
However, I still can not figure out why I can't go backwards. It will ONLY go forward no matter what you do. If you try to select a cell behind or in front, it just tabs to the next cell in the array. Can anyone help before end up sitting in the corner of the nut house crossed-eyed and drooling

View 9 Replies View Related

Xy Chart In Vba, Order Of X And Y

Jun 9, 2007

I need to create many XY charts in a VBA macro. For each chart, I need to select a particular column for the X dimension, and a particular column for the Y dimension. When I use a named range to define the X and Y columns, my macro works fine for those instances when the X comes first. However, if my desired Y dimension comes first, I cannot find a way to correctly select these.

The context is such that my spreadsheet always has the same data fields in the same columns, but the numbers of rows vary. In addition, I need to dynamically select which rows to use, based on the values in the columns to be plotted. I’ve figured out how to do this within the macro, except for those instances when the Y column comes before the X. An example when this works:

' X-Y chart, Field10 vs. Field12
Names.Add Name:="newRange", RefersTo:="=$K13" & ":" & "$K" & FirstBias _
& ",$M13" & ":" & "$M" & FirstBias, Visible:=True Range("K1").Activate
ActiveChart.ChartType = xlXYScatterLines
ActiveChart.SetSourceData Source:=Sheets("Raw").Range("newRange"), PlotBy:=xlColumns
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Field10vsField12"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Field10 vs. Field12"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Field10"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Field12"
End With
ActiveChart.HasLegend = False

In the above example, variable ‘FirstBias’ is computed previously in the macro. I realize that I can rearrange columns in my spreadsheet to avoid this, but that is much less convenient, and less elegant, and I think there must be a way for a macro to do this automatically. I can do it interactively by cutting and pasting the data ranges in the chart wizard dialog, but I need this to be automated. I also figured out how to automate it in the case where the X and Y columns have fixed rows, by adding the commands below:....................

View 8 Replies View Related

Results In Alphabetical Order

Jul 8, 2014

Example Data...


I have this formula in cell C1, filled down to C7:


This creates a list of cells from column A where the correspsonding value in Column B is greater than or equal to 5.



Any way that would generate these cells in alphabetical order making it look like this:



View 8 Replies View Related

Establish Tab Order In Excel

Dec 10, 2013

This was the code I attempted to use previously

Private Sub Worksheet_Change(ByVal Target As Range)

Dim aTabOrd As Variant
Dim i As Long

'Set the tab order of input cells

[Code] .......

View 1 Replies View Related

Reverse Order Of Cells?

May 12, 2014

Okay, say I have a spreadsheet like this:

Cell1 Cell2 Cell3
Cell4 Cell5 Cell6

How do I make it:

Cell6 Cell5 Cell4
Cell3 Cell2 Cell1

View 1 Replies View Related

Get A Top 3 Amount From A List That Have Several Order?

Aug 11, 2014

get sorting out top 3 clients with the total amount.


Company Name



I found that =LARGE only work for single cell name with single value instead of multiple cell that may contain same name but different value and add them up.

View 14 Replies View Related

How To Automatically Re-order A List

Dec 19, 2005

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.

View 14 Replies View Related

Paste In A Reverse Order

Sep 5, 2008

I have a list like this

Morris Minor
+ about 300 others

I need to copy these and then paste then in another column in the reverse order. Is this possible ?

View 2 Replies View Related

Order Selections Contigously

Dec 15, 2008

On one sheet I have a long list of items which I need my users to scroll down and, when needed, fill in a value next to the appropriate item in the list. Most of the list items will not need anything inputting against them. Then on a different sheet I need a nice tidy summary list which only shows those list items which have an input against them.

The bit I can’t do is getting these few items to display (on a separate sheet) in a nice neat all together, contiguous way - ie with no gaps. Also I need to populate this summary list automatically. ie after each entry.

View 2 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved