Search results for query: *

Skip, Nothing else is happening in the workbook. I just thought it would be "cute" if there were a way to write something that will move the cursor from B1 back to A1 without me manually hitting the left arrow key. It's just a purely lazy notion that occurred to me is all. goopit

G'day All, I'm wondering if there is a way to write a VBA that will return the cursor to cell A1 after a date is entered and the Enter or Tab keys have been struck. The sheet I'm working on is very simple. A date is returned in cell B1 after a date is entered in A1 based upon this little...

Hello All, I recently got the Acrobat 8.0 upgrade. One reason was to give our reps the ability to digitally sign documents if they are using Reader 7.0 or 8.0. I was able to successfully test the process by e-mailing PDFs to my boss's terminal. He uses Reader 7.0. However, the files I've...

Lovely idea, Skip. Thanks so much. Have a star. Scott

Hello All, I was recently sent a file to work with which, at times, contains multiple values in one cell. For example, one cell may have "Cynthia, Suzy, Susan G.". I've been asked to run a total of how many instances one particular name shows up within a given range, but there really is no...

Brilliant! Thank you very much for your help, John. Have a star. Scott

Good Day All, I'm having trouble writing a concatenation so that when I grab the text from the cell I want it will look like this: "AMAZING GOOP",. I want to add quote marks before and after the text and finish it off with a comma at the end. Any and all help will be much appreciated...

LB, Thank you for very much for the prompt and accurate response. Scott

Hello, With the formula below, I am having trouble getting the correct date to show. For instance, say the Ending Date for the current year range is 02/01/06. Using this formula, I get an Ending Date for the same range last year as 02/28/05. I would like it to return 02/01/05 instead...

John, The second formula there is a beauty! Thank you very much for your quick and lovely answer. Goopit

Hello, I was given a file today by one of the bosses. He absolutely will not let me re-format his data to make it easy to total. He likes the way it looks on the page. There are two columns: # of stores Status The rows look like: 59 Active...

Hello, I wrote the following macro to group and sum invoices by month. When I use the keyboard shortcut on results for a different company or a different date range, the message reads, "Run-time error '1004': Cannot group that selection". This is the code. Sub COOP() ' ' COOP Macro ' Macro...

Yes, I suspected that would be a big stumbling block. Oh well, thanks for the info. goopit

Hello, I have a range of cells with values and would like to be able to figure out which of them, if added together, would equal a target value. I have been through faq68-4742, but the Sorter does not seem to be the answer because it changes the values of the cells in range and I can't have...

Argh! It was right there in front of me the whole time! Thank you, Skip. goopit

Hi, I am curious if there is a faster way than manually highlighting a print area and choosing Selection for each instance of a subtotal in my sheet. Ideally, it would print whenever it saw a change in the column for sales rep number since each sales rep company has its own subtotal. It would...

Sorry. I didn't make it clear that I still want to print the rows above that rep's subtotal that went into calculating it. Depending upon the viewing choice, grouping just hides those rows, right? goopit

Hi, Perhaps this belongs in a VBA forum. My apologies if so, but I am curious if there is a faster way than manually highlighting a print area and choosing Selection for each instance of a subtotal in my sheet. Ideally, it would print whenever it saw a change in the column for sales rep number...

Skip, I apologize, but I don't understand how Mail Merge will understand to pull only those products that, let's say, account 431340 buys. How much VBA coding are you talking about, anyway? Thanks, goopit

Hello, The company needs to send a letter to about 600 of our accounts, advising of new case UPC numbers. I welcome any suggestions to make this as trouble-free as possible. All the account numbers, names, addresses, etc. are on one worksheet. Another worksheet contains the list of account...