Posts by 312kclark

    This is what I need done, I am needing to use a command button to go to a worksheet (in the same workbook) and highlight a range of cells, defined from two cells A1 = "A17365" A2 = "ZA30561" ~ copy those cells and paste them on another sheet within the same workbook such as the upperleft cell would be designated by me "A65594" as an example. Can this even be done? My alternative method is not going to work because it will enlarge the workbook and make it too slow to use. I have a DATA worksheet that has 35367 rows/16 columns and I am taking 10000 rows/16 columns and pulling each cell from the worksheet that I have all the data on. This data is only for one month and is extracted from the huge data worksheet. The one month data is only about 5000 rows.

    I don't believe Auto-fill will work for this. I have many things that need to be looked at. I have attached a SAMPLE workbook. This workbook only has 4 worksheets. The DATA worksheet is what i am pulling from another workbook and provides all the data of which i will use to pull information for reports, and I still haven't got it to pull the data from the other workbook without manually copy and pasting, which I would just like to get that done as the workbook is opening up. I want to extract from that worksheet, but only one month (which would be 1000's of rows, which I have done on the CONFIGURE worksheet. I had problems with the dates because some were date and time based from the DATA worksheet. I want to try and select a range of rows from the DATA worksheet, copy and paste to the CONFIGURE worksheet. The way it is set up now, this will be a huge workbook because everything is formula based in extracting data and getting results, I have had to cut it down and even compressed it to get it attached. If you can wrap your head around with what I trying to do, I believe you can give me some suggestions that will work better. if you need any other information, just ask. Thank you in advance for any suggestions with this.


    Kenny

    Thank you for your response, it was very helpful and appreciated. Once I get all the data from the other spreadsheet, I now have 12 columns and about 20000 rows of data. Of which, I need to extract only certain rows out based on certain criteria of what the row contains, such as part number, date of issue, date of sale, etc... any suggestions to move these rows to another worksheet within the same workbook, using VBA, would be appreciated.


    Thank you,

    Kenny

    I am looking for a VBA Code to allow me to copy a whole worksheet from a completely different workbook to the current workbook that I will have open and using. Let me see if I can explain what is going on. I will extract data down from a program that I use at work, I will save this to a workbook named “PROG1”, this data will be used to construct worksheets to display the data. The worksheet to copy is on another server, which the path would be “R\: ...”, I will enter this information in. I’m not sure if this can be done, but I would like to know if it is possible. Thank you in advance for any and all help.


    Kenny

    Ok, took me a little bit to see what is happening, but I am finally seeing that the module will print off each individual page to a PDF. Even though I cannot figure out what the a, b, i, x, & y is, I believe all I need to do now is correct the printer, correct? Is there also a way to make sure that it will print using "one sided print", my printer driver at work is setup for "two sided printing". What do I correct to print to my printer?


    Thank you so much for your help.


    Kenneth

    I'm trying to make it work, but between not understanding it and it not working the way I feel it should, because I can't find the PDF that it creates. I just want to be able to print from the CONFIGURE worksheet, the pages of the CUSTOMER ORDERS worksheet. I'm trying to make it work, I changed out the msgbox and now it looks at the cell B1 from CUST ORDER. I won't give up, but I just have to wrap my head around it. i thank you for putting your time and knowledge in this, i am grateful for your help.


    Kenneth

    I thank you for the extra help, but I’ll have to say this is a little deeper than I anticipated, I’m not that savvy on modules, I usually just do VBA straight from command buttons or check boxes or list boxes. I understand some of it, but I’m lost within some of the code. I’m not even sure where/how to insert it in VBA. Sorry, I’m not too knowledgeable in all this. I thought maybe a simple fix to the command button I now have, would work. To make it go to the CUSTOMER ORDERS worksheet, ask for/confirm the number of pages to print, capture the worksheet pages and print and then return back to the CONFIGURE worksheet.


    Kenneth

    My need is not to reproduce any worksheet or sort anything, just to print the CUSTOMER ORDERS worksheet from the CUSTOM command button on the CONFIGURE worksheet. I need to have control of the number of pages to print off of the worksheet, from 1 to (n). The VBA Code I have now doesn’t print the CUSTOMER ORDERS worksheet, instead it comes back and prints the CONFIGURE worksheet.


    Kenneth

    I have an Excel workbook, with many worksheets, I have one worksheet that is used for a Central Command Center, it will tell me general information about all the other worksheets and with that information, I will know if specific worksheets need to be printed. The worksheets that need printed are already formatted, I just need to print those out, (which contain over a hundred pages each) but not all pages will need to print from any given worksheet. I am looking for a Command Button to be used to print a worksheet, that is already formatted with multiple pages, but I don’t want to go to the worksheet and have to do a CTRL-P and change the from/to pages, to print the pages I want printed off. The print will always start with the first page, but I am looking to control how many pages to print, it could be over 100. Last, I would like to be able to set this up so that the printer always uses “one sided print”, because the printer I use is defaulted to a “two sided print”. I know these are many things to ask for, but I feel it can be done. Thank you in advance for your solution.


    Kenneth

    I have reattached a clean copy of the workbook. Please understand that I am not trying to restructure the worksheet in any way, i am just trying to print it from a central location.

    The CONFIGURE sheet is my central location and i am trying to print off the CUSTOMERS ORDERS worksheet, but not in it's entirety, just those pages that are defined in cell B! of CUST ORDERS. The VBA in the command button (CUSTOM) on the CONFIGURE worksheet doesn't work correctly, but the command button (PRINT ALL) on the CUSTOMER ORDERS worksheet works fine (pretty much the same code). As I said in my previous post, I also would like the command button to print the CUSTOMER ORDERS worksheet (# of pages 1-??), a CANCEL execution, and if possible, to change the default to "one side only" from the printer that is set up as two sided printing. Thank you in advance.


    Kenneth

    I believe you are making this little more difficult that it should be. I do not need the help to sort anything, this is already done when I download the linked file that populates the STARTUP worksheet. I just need the VBA - command button to print the CUSTOM ORDERS worksheet. It is already formatted to fit on a 8 1/2 x 11 sheet of paper and the way I need the worksheet to be printed out. There are 150 pages but all may/may not be populated. The number of sheets to print will come from cell B1 of CUST ORDERS. I can use the command button on the CUSTOM ORDERS worksheet, but because I have about 50 other worksheets like this one, I want all sheets to be printed from one central location. so that I can pick and choose which worksheet I want to print out. I tried to use the same code as on the worksheet, but it just came back and printed the CONFIGURE worksheet. I don't mean to sound ungrateful for your help, but I do need the right solution to my problem. Please, go to the CUST ORDERS and click on the PRINT ALL command button (select to print to file or PDF if you don't want the 23 pages to print on paper), and then go to the CONFIGURE worksheet, click on the CUSTOM command button, it will print the CONFIGURE page only. If at all possible, i would also like a CANCEL to show up in case i don't want to print off the worksheet. My printer is defaulted to a 2 sided print, so if I could possibly get a code to change that setting just for this excel workbook, that would be a great help as well. As always, i thank you in advance for the solution.


    Kenneth

    I would like to reach out to anyone that might have a solution to this problem. I have a workbook that I am trying to print however many pages that are counted from a specified cell from another worksheet, by using a command button from one worksheet to print the page range of another worksheet. The pages will always start on page 1 but could end on page 150. The specified cell is already defined for the last page number, but the VBA code I am using only prints the page of the command button. I need it to print the worksheet with all the pre-defined pages. Thank you in advance.

    Kenneth

    Ok, I feel like it is unclear of what I am trying to get accomplished, I just need the 23 pages on the CUST ORDERS worksheet to print out from the command button on the CONFIGURE worksheet, but I need it to print only the pages that have data, which are only 23 of the possible 150 on the CUST ORDERS worksheet. I can print it off from the worksheet itself, but I’d rather just do it from the CONFIGURE worksheet. In the end there will be about 50 different worksheet that I may have to print to, but not all 50 all the time.I figured out that if I can pick and choose what to printout from one worksheet, it would be quicker and easier. I only have one worksheet in this workbook so that I will be the model and I can structure all other from it. Thanks again in advance.

    Kenneth

    Yeah, the workbook is huge, but it works, I deleted enough just to get it to you. All i am wanting to do is print from the CONFIGURE worksheet and it print the same way as it does if i were on the CUSTOM ORDERS worksheet. Click on the command button in both sheets to identify what is and what isn't happening.

    Thank you in advance,

    Kenneth