At my workplace we have 10, however, I use 360 at home. The formulas you provided worked like a charm. Thank you again.
Posts by 312kclark
-
-
Thank you so much, this works so well, and I have no problems with it at all.
Kenny
-
I have a workbook that has a a table comprised of 6 columns and 15 rows. This is small compared to the 1000's of rows I usually have. I am looking for a formula that will lookup and match all of column 1 values, and add all of column 5 values that match each row of column 1. I have attached a sample of this with information of what I am looking for.
TIA
Kenny
-
I did that but I received the same result
-
What does “className” missing or invalid mean? This message pops up beside the attachment when I try to upload it. The file is under the 16mb limit. Can you help with this issue?
-
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.
-
This wont upload, says the parameter "className" is missing or invalid? I cannot figure it out how to get it to accept it. What does that mean?
-
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 do remember doing this from time to time, but never thought of doing it with this workbook. Is it possible to make a VBA Code with a macro to do this for me instead of manual clicks on the ribbon?
-
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
-
Thanks again for all your help and support, and I appreciate all the knowledge you gave me, stay safe.
Kenneth
-
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?
Code
Display MoreSub Maybe_C() Dim sh1 As Worksheet, sh3 As Worksheet, i As Long, c As Range Dim a As Long, b As Long, x As Long, y As Long, j As Long, ptp As Long a = 4 b = 40 i = 2 Set sh1 = Worksheets("CUST ORDERS") Set sh3 = Worksheets("CUSTOM ORDERS") For j = 1 To sh1.Range("B1").Value x = b * (i - 2) + a * (i - 1) y = x + 40 With sh3 .PageSetup.PrintArea = .Range("A" & x & ":V" & y).Address .ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & "CUSTOM ORDERS " & sh3.Cells(x + 2, 9).Value & ".pdf" End With i = i + 1 Next j End Sub
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 -
Thank you for your interest. Have a happy Easter.
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