Excel Idea - but can't figue it out

[georgyboy]

Had an idea, Workbook with 5 worksheets. First sheet is a running total sheet, other pages are order sheets.
Is it possible to, once the retailer has finished their order, print a page out that lists what they have ordered. At the moment I can only get all the pages to print, but what I want is to have Excel recognise what has been ordered and just print that out.
Saves paper and make less clutter for customer
Does this make sense?

 

[dk87]

May be store the date and time somewhere, and use VBA to select a cell range based on current date and time?

 

[SkipVought]

Need to know more about the structure of the data in your workbook.

Specifically, what uniquely identifies any particular order?

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[georgyboy]

Okay, heres the info on the workbook -

Colour/Style/Color Month Required 6 7 8 9 10 11 12 13 14 Total Ex-GST
Sep Oct Nov Dec Jan
3085 Pitch (RRP 999.99) 99.00
Black
White
Brown/Orange
Sage
Total Pitch

Does this help?

 

[SkipVought]

Please copy 'n' paste into a NotePad and add spaces so thing line up in the proper columns.

Then copy 'n' paste what you formatted, in this post again, please.

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[georgyboy]

Colour/Style/Color Month Required
Sept Oct Nov Dec Jan 6pk 12pk Total Ex-GST
HEADWEAR
HW7002 Fast Trak
RRP $xxx xxxx
Black
White

I hope this is better for you, thanks for helping

 

[SkipVought]

NOTHING lines up.

This example does not correspond to the original example. Where is " 6 7 8 9 10 11 12 13 14"????

You appear to have ONLY 3 columns:
[tt]
A: Colour/Style/Color
B: Month
C: Required
[/tt]
Am I correct in assuming...
[tt]
Colour/Style/Color Month Required
Sept Oct Nov Dec Jan 6pk 12pk Total Ex-GST
HEADWEAR
HW7002 Fast Trak
RRP $xxx xxxx
Black
White
[/tt]
This data has a DIFFERENT format than the PREVIOUS example. I AM TOTALLY CONFUSED!!!

Your original question regarded printing an order on multiple sheets, I assume.

How do YOU identify what's been ordered and what has not?

What is an EXAMPLE of what you want to print and what you DON'T want to print???

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[georgyboy]

yeah sorry Skip, sizes where meant to be included but obivously didn't

ill try to reask the question -
what the aim is to print information from multiple sheets onto one sheet of paper or two (depending on how much info there is) instead of printing the entire workbook
ie. An order composed of 24 shoes total -
but the shoes ordered are three different styles with 8 different sizes ordered in each style =24 pairs

How would you get just that information printed onto a single page ?

How can I get excel to scan a worksheet find what has been ordered and only print that?

If this isn't any clearer I can email you a copy of the doucment

 

[SkipVought]

It seems that you have a vast blank form that may have one piece of order data on it.

Why is this order spread across 5 sheets?

Would it not be a better approch to give the person ordering, dropdown options, so the the entire order can be compact and concise?

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]