software

I have several worksheets that I would like to combine the data from onto one
worksheet. Is this possible and if so, how do I make it work?

This works, but is there a quicker way to put the data onto a master sheet?
I have to change the formula at each cell and then do the update value after
each cell. I have over 15 worksheets in the workbook that go from A2 to V2
with sign up information.
Thanks for your help!

quot;Gilbert De Ceulaerquot; wrote:

gt; if you want the value of a1 of SHEET1 of WORKBOOK1 then put
gt; ='[WORKBOOK1.xls]SHEET1'!$A$1)
gt;
gt; you could make this very easy to change (the names of the workbook, or the
gt; name of the worksheet)
gt; by putting quot;WORKBOOK1quot; in a1 of your destination-sheet
gt; and quot;SHEET1quot; in a2 in your destination-sheet
gt; then the formula would be =INDIRECT(quot;'quot;amp;A1amp;quot;'!quot;amp;A2)
gt;
gt; if you want an error-trap (in case A1 or A2 does contains wrong data)
gt; the formula becomes =IF(ISERROR(INDIRECT(quot;'quot;amp;A1amp;quot;'!quot;amp;A2)); quot;something is
gt; wrong !quot;; INDIRECT(quot;'quot;amp;A1amp;quot;'!quot;amp;A2))
gt;
gt; does this help you ?
gt; GDC
gt;
gt; quot;lrobin65quot; gt; wrote in message
gt; news
gt; gt;I have several worksheets that I would like to combine the data from onto
gt; gt;one
gt; gt; worksheet. Is this possible and if so, how do I make it work?
gt;
gt;
gt;