Search results

Hi luke, I cannot see any header when i see the print preview when i add the above code in the sheet.Please see the sheet where i added the code im using xl 2003. http://speedy.sh/cFdpJ/Samplewrkbk.xls Please let me know Thanks,

Hi Luke, To be clear i have uploaded the file. http://speedy.sh/ntCYr/Samplewrkbk.xls if you see sheet pivot and if you select 2 vendors from drop down you will see different range of data.I want to print these data as per the vendor selected(in this case only 2 vendors are there,can b many...

Hi Luke, thanks for the prompt reply,i saw the video but it seems that the dynamic range offset formula will not work in pivot table that i created as you adviced.Is it so?

Hi Luke, Please explain your comment-Sure thing. If you manually setup a print range, you can then check the Name Manager and see that XL has defined print_range. You can then modify the formula to make it dynamic. do you have any example page or link for this to understand better.

Hi Luke, thanks for this but even i wanted to give a fancy look to my report if i would have created one datavalidation list and once i have selected any supplier name it would have resulted in giving all the realted rows but again thanks for pivot idea ,i dont know why it did not came to my...

Hi Everyone, I have a task to do where i have a raw data in which i have various Vendor names and my task is to create a list or combo or any dropdown and for one vendor name there are many Tool numbers so I want that when i select any one vendor name it shuld show all the corresponding data...