Recent content by indesignkat

This may be too obscure, but I'm trying to automate running a GR55 report in SAP. Everything works fine, but some of the GR55 reports generate a pane on the left of the SAP screen that can be expanded to show a list of company codes/regions. Clicking on a line in that pane brings up the data...

Amazing, as per usual. You guys are the best.

I forgot to mention that there can be empty cells in B:K, if that matters. I don't want it to return a zero because it matched an empty cell.

Hello glorious Chandoovians, I'll set this up with a very simple example: In column A we have an id code. In columns B:K we've got numeric values. I want to find the minimum of those values. That's easy enough. Now let's complicate it by saying that each row has an id code and values...

Using ctrl-g to select visible cells only works fine for him, and that's what he's currently doing as a workaround until we can sort out why the default behavior is so odd. And SirJB7, the file he's using doesn't matter. Any file shows this behavior. EDIT: the thing that's nagging at my brain...

Thank you for the reply. As noted in my original post, both computers are running office 2010 v14.0.4760.1000. 32-bit, if that matters. Sample file, original file, results are always the same. When we do it on his machine, it copies & pastes the hidden rows as well as the visible ones. On...

Hello, My colleague recently returned to work here with a different computer and it's acting differently than he is accustomed to. When working with a filter and copying data to paste to another workbook, it is copying rows that are filtered out (hidden) and pasting them into the new book. He...

ok, I think I have it sorted... I put a line number (26) in front of the first line after Do and then in my error handling I changed "Resume Next" to "Resume 26" and now it seems to be working as I intended.

Hello, I have a spreadsheet with a list of document numbers. I have vba code that runs a specific transaction code in SAP, pulls up the first document, then prints the invoice attached to that document, then moves on to the next record. I have a snag when the document doesn't have an invoice...

all hail the Ninja. thank you!

sure, see attached.

Hello wonderful Chandoovians, I have a spreadsheet I send out to ~50 people, many of whom would need special training to filter the results much less get where they need to in a pivot table, so I need to stick to the format they're accustomed to. At least for now, maybe someday I can get them...

Here you go

In a very large data table I have ID numbers in column A, many other columns of data, then at the end a column that flags rows as needing attention. I use this to create a worklist. My column at the end is a simple nested IF statement. If all 3 criteria are met it returns a 1, otherwise it...

I'm guessing it's just an Excel oddity, but when I sum numbers I'm sometimes getting ridiculously tiny numbers in scientific notation instead of just getting a 0. For example, copy/paste the below numbers into a blank sheet. If I click on the top one and drag down, the little info area on the...