LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Print in continous serials from a Sheet

Hello All Experts,

I am using OfficeXP and have the following problem:

I have many sheets for example Pc and PcDetails, Printer and
PrinterDetails....etc

PcDetails sheet is designed as a form which extracts data from Pc sheet
using various Vlookups. In cell C5 of PcDetails I have used a Range
Name 'PCList' (PcList is the ID numbers of various PCs) from the Pc
Sheet. All relevant details are shown according to the choice selected
in Cell C5.

My problem is that I have to print about 10 to 20 PcDetails sheet and I
have to choose it one after other.

I need a solution which should show me a InputBox where I can input the
starting number (ID) and the ending number (ID).. which would then
print the PcDetails one after other...the print range is
'PcDetailsPrint'. Please note that I always print in continuous
serial for eg.. 1 to 10, 15 to 30...and so on.

Any help would be very much appreciated.

TIA

Rashid Khan

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT NON-CONTINOUS CELL Harsh Bahal Excel Worksheet Functions 2 March 3rd 09 09:39 AM
Continous number box Egypt709 Excel Discussion (Misc queries) 1 January 23rd 09 11:05 PM
Sum of continous cell Man Excel Worksheet Functions 3 July 14th 08 05:45 PM
Print row labels that are continous Luke Excel Discussion (Misc queries) 1 November 23rd 07 01:37 PM
countif with non-continous ranges Debbie Excel Worksheet Functions 7 May 10th 06 09:00 PM


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"