find data in named range.

S

Stephen King

if not very good at using excel or formulas so I need to ask.
I have a sheet that has 15 blocks on it I can name the blocks to simplify
such as Level_1_block_1 through to level_3_block_5

what I am trying to do is find which block has data in it and which block
was has the latest data.

this is because not all blocks have data the data I need to find is / as
this is synced in from a pda.
when I find the latest block with data I need to merge this to a word
document via a mail merge program

at this point though I'm happy just to discover the block and retrieve its
name.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top