Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT NON-CONTINOUS CELL | Excel Worksheet Functions | |||
Continous number box | Excel Discussion (Misc queries) | |||
Sum of continous cell | Excel Worksheet Functions | |||
Print row labels that are continous | Excel Discussion (Misc queries) | |||
countif with non-continous ranges | Excel Worksheet Functions |