software

Hi All,

Right, I'm looking for a formula that will copy text from column A in
worksheets 2-5 into column A of worksheet 1?

E.G. If another name is added in column A, row 4 of worksheet 3 I need it to
appear in the same column and row of worksheet 1.

Any suggetions? - Be gentle, I'm an excel idiot!

Tomo

SO what happens if another name is added in column A, row 4 of worksheet 3 and
in column A, row 4 of worksheet 4?
which one would need to be displayed in the same column and row of worksheet
1?
You can however have data from sheet2 in columnA appear in sheet1 Column A
in the same row as it originally is, then maybe have data from sheet 3 appear
in Column B in the same row etc...???
use this in Sheet1 cell A1, you can drag it down or even over if you like.

=IF(Sheet2!A1lt;gt;quot;quot;,Sheet2!A1,quot;quot;)

Change sheet Name where you need

quot;TheTomoquot; wrote:

gt; Hi All,
gt;
gt; Right, I'm looking for a formula that will copy text from column A in
gt; worksheets 2-5 into column A of worksheet 1?
gt;
gt; E.G. If another name is added in column A, row 4 of worksheet 3 I need it to
gt; appear in the same column and row of worksheet 1.
gt;
gt; Any suggetions? - Be gentle, I'm an excel idiot!
gt;
gt; Tomo
gt;

I was hoping it would 'auto sort' or something fancy!

I'll try your solution and see what happens.

TKS!!!

ufo_pilot wrote:
gt;SO what happens if another name is added in column A, row 4 of worksheet 3 and
gt;in column A, row 4 of worksheet 4?
gt;which one would need to be displayed in the same column and row of worksheet
gt;1?
gt;You can however have data from sheet2 in columnA appear in sheet1 Column A
gt;in the same row as it originally is, then maybe have data from sheet 3 appear
gt;in Column B in the same row etc...???
gt;use this in Sheet1 cell A1, you can drag it down or even over if you like.
gt;
gt;=IF(Sheet2!A1lt;gt;quot;quot;,Sheet2!A1,quot;quot;)
gt;
gt;Change sheet Name where you need
gt;
gt;gt; Hi All,
gt;gt;
gt;[quoted text clipped - 7 lines]
gt;gt;
gt;gt; Tomo