Compiling data from 2 sheets

M

M

I am trying to compile data into a single table (5 columns
wide) from two worksheets. The problem I am having is
that the number of rows on both lists is going to vary
over time and I need to pull it into a single list
(without blank rows). I know there is an easy way to do
this without using a macro, but I can't seem to figure it
out. I have tried using something like this, but without
success:

If(isblank(Sheet1!a2),(sheet2!a2),(sheet1!a2))

What I really need is a formula that will recognize when I
have reached the last row of the first sheet and need to
swtich over to the second sheet.

Any ideas?
 

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