Search results for query: *

Skip, you're getting way over my head. Would you be amenable to my sending you the file and taking a look at it to see if you can figure out what's wrong with the macro? Thanks, Texanite

Keyboard shortcut is still associated with the macro.

I went to Macro, Edit and pasted your macro then saved it. Don't know whether this has anything to do with it or not but this spreadsheet was imported from Oracle. All text is in column A. But that shouldn't make any difference should it? When I recorded the macro, column A was the only...

I copied it over my macro and it just sits there and bleeps at me everytime I hit he shortcut... Nothing happens.

I have tried and tried to set up a macro to find and delete the next 8 lines within the spreadsheet. Nothing seems to work! Below is the Macro. Can anybody fix this or tell me what I am doing wrong? The Macro quits after the first search. It acts like it is operating as an absolute but I...

I have a text column "B" and in several cells the word "Rebill" appears. I would like to have a formula that works in conditional formatting that would allow me to highlight in yellow all cells with the word "Rebill" in the cell. The word does not appear in the same place in the string all the...

I have a 10,000 row payroll spreadsheet that I need to work with the totals and subtotals without the detail. Part of the problem is that when I collapse the subtotals they show up in the amount column (K) but I need the information that is in column I in order to do my sorting. How do I get...

Is it possible to embed an image in an Excel header and/or footer? I tried copying it and that didn't work. Anybody have a suggestion? I'm trying to get a logo into the header. Thanks, Texanite

I have a column of numbers and some are text and some are values. Have tried everything to turn the text numbers into values (tried cut & past values and tried =value) and nothing seems to work. Am trying to sort on that column and until I can resolve this problem, it won't sort correctly...

I have 4,00 rows and in one column each cell has a number, a space and the word Total after the numbers, i.e, 123456 Total. I need to get rid of the space and word total. Surely there has to be a simple way to do that. Thanks, Texanite

I keep getting an error message that "File Not Found". These are all in the same file, just different tabs. Thanks, Texanite

Ken, I think maybe I have not explained this too well. The following are the columns and what I want to do with it. FY Column I 4260 24 4 350 80 CC Column A 02 04 06 02 03 CC Column C 4 24 80 350 4260 The FY Column I has 550 Rows (some rows are blank) The CC Columm C I am trying to match...

Thanks, Ken but that didn't work either. I played with the ranges but it still wouldn't work. Texantie

Dyan, the formula you gave me does not match the numbers. What is in sheet 1 A1 does not equal what is in sheet 2 A1. I must find it in list on sheet 2. Thanks, Texanite

Thanks for the help. But although it's true I can copy the first two digit numbers, that doesn't address the last 4 digits I need as a end result (see example in original post). True, I can copy the two digit number How do you achieve that? Thanks, Texanite

I have a spread sheet with two tabs one called FY and another called CC. In the CC spreadsheet column A has a series of two digit numbers from 01 through 04 (with the leading zero) and column C has a series of numbers with no leading zeros; the numbers can be up to 4 digits. In tab FY column H...

OK, that was the problem for the most part, the Rollup sheet was not sorted. I was also trying to compare a character with a value so fixed that and sorted the Rollup sheet and it works on all 20,000 rows EXCEPT the first row! Why won't it work ont he first row? Texanite

That is indeed what I'm doing. However, tried your formula and am getting a #N/A result. There should be a match for everything within the Rollupsort table. Thanks, Texanite

Need vlookup help on the following problem. I have a spreadsheet with a tab called "Rollupsort" that has a column A & B through row 415. I have another spreadsheet with a name tab of "Account Analysis". I am trying to find a match in column A in "Rollupsort" with...

Duhhhhhhh..... Thanks, Texanite