Search results

OH YEAH -- YOU ABSOLUTELY ROCK THANK YOU x 1e6

Hi all -- I work at a plant that bottles milk and juice. Every day I have to generate a very time consuming report from all of the previous day's work. This report is generated from a DB we utilize and has 400+ rows from weight samples taken through out the day. The question I have is two...

our printer is a Sharp UD PCL6 and when I go to the drop down you indicated I get "letter", "legal" and "More Paper Sizes", when I click that I get this menu which even going through all the tabs doesn't let me choose a custom size

I went to devices and printers, etc but there was no way to add a paper size. I really am starting to believe this is a printer issue more than an Excel issue. I am going to my spreadsheet to PDF, then print so them so my sizes don't get all goofed up. thanks for your help

Excel 13 for windows

Hi Hui -- Thanks for getting back to me so quickly. I understand it is called Tabloid (or sometimes I have seen it called Ledger), the problem is Excel is not even giving me that option on the drop down at all. I changed printers and then found it on the drop down, but when I printed the...

Hi all -- I have a large spreadsheet that I print out on a ledger 11 x17 size paper and for some reason, Excel has decided to get rid of this size paper in printer setup. I made sure to have the paper loaded but it either doesn't give me that size for a choice or it prints a forth of the...

OK I feel a bit humbled, that's what I get for looking at the same numbers and expecting something different to pop out. thanks Lawrence

Hi Ajesh -- I tried this and still I am getting the 1:22 instead of 1:06. *SIGH* Any other thoughts? thanks

Thank you for the [h] advice, but I tried it with this column of information and the average is not working out correctly. I manually figured out the sum and got 5 hour 30 minutes with an average of 1 hour 6 minutes, not 1 hour 22 minutes. Any thoughts on what I am doing wrong? 0:00:00...

Hi all - I am working with times of job completion (not time of day) and have a column formatted hh:mm. When I sum it or average it, I only get a number < 24 hours. I have tried to over ride this by doing =if(mod(sum(range), 1), sum (range), sum (range)+24) with no luck. With the average...

Hi all -- I love this site -- have learned ALOT from it, but now I have to learn ACCESS. Can anyone recommend a blog for ACCESS that is close to as good as this one (though when you are the best; there is no competition ;))? If any of you are ACCESS trained, this is the first hurdle I have...

just copying Luke M so that would be his call:confused:

That is what I thought you would say. I agree with you that it would at best be an "ugly, unstable beast" but think of the challenge to make it work -- fun fun:) seriously though if you have some thoughts on how to make this a bit more stable, don't be shy. Unfortunately our budget doesn't...

We've looked at combining everything, but unfortunately different people are working on the various workbooks at the same time so I don't think that would be viable not to mention each of the individual workbooks are rather large by themselves and combining them would just slow everything down...

Hi all -- A friend asked me what the best way to link together 5+ network workbooks that different people use throughout the day. There is no guarantee that all the workbooks will be open at the same time. I thought if we had a "bridge" workbook that is always open (can that be stored on the...

whoa -- this is deep. I'm going to have to look at this deeper to see what is going on. thanks:)

Hi Debraj- I am not sure what the "row" command is or how it works, could you explain what it is and what it does. Thanks Lawrence

Hello good sir. Here is the modified spreadsheet that works. Originally each section with bold borders was next to each other instead of a long column. It works I am just wondering how to write better code. L.Dodge

Hi all -- First thank you to SirJB7, without your help on a different problem I would not be this far. I have a table 10 columns and 25 rows -- odd numbered (*see below for why I am not saying Column A,B,C etc.) columns have a sequential number, while columns have a factor of 0.015 starting at...

Thanks a lot, it works GREAT once I figured that I had to put a large number in cell A7 to accommodate for A7 - A6, without which everything over 160K went to 18,000 The uploaded sheet has different values and what they should be (rounding ones column aside) before I put 500000 in cell A&.

I definitely like your signature block. What type of bike do you ride? Where do you call home when you are not traveling for the sake of traveling? Lawrence

the uploaded file has better column separation (the colors are just to highlight different columns -- they can be deleted)

Hi Narayan -- Currently this is what the table looks like (sorry the columns are crunched): 050,0000.80 50,001100,0000.70 100,001150,0000.60 150,001200,0000.50 200,001250,0000.40 250,001300,0000.30 300,001350,0000.20 350,001500,0000.00 500,001600,000-0.20 600,001750,000-0.40 750,001850,000-0.60...

Hi again -- The second question about looking things up in a range is more complicated. On a different problem than part 1 I have the ranges of: 100,000 - 120,000 lbs. --> 0.25 120,001 - 140,000 lbs. --> 0.30 140,001 - 160,000 lbs. --> 0.35 160,001 - --> 0.40 The way this...