Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to copy text from a column in different workshhets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to copy text from a column in different workshhets
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!A1<"",Sheet2!A1,"") Change sheet Name where you need "TheTomo" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to copy text from a column in different workshhets
I was hoping it would 'auto sort' or something fancy!
I'll try your solution and see what happens. TKS!!! ufo_pilot wrote: 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!A1<"",Sheet2!A1,"") Change sheet Name where you need Hi All, [quoted text clipped - 7 lines] Tomo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |