Converting a form into a worksheet

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have 3 worksheets in my workbook. On worksheet one there is one form
that is copied down ten times. I need to be able to convert the
information in that form into the two following worksheets. I cannot
make one formula on worksheets two and three and drag the formula down
because the inoformation in the form is not on consecutive lines. How
can I write this formula so that it will be able to drag down in
worksheets two and three?
 
Hi
post some more details in which cells exactly your information is.
Maybe an OFFSET formula will work then
 
You must log in or register to reply here.

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

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
how do i copy the result of a formula into another worksheet as te 3
How do I copying data from a cell on sheet to a diff cell/sheet 1
Basic Question on autocomplete function 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Compare data (2 columns) from 2 worksheets within a workbook 2
need to automate a sheet re-organization 1

Back
Top