Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use cell address
Hi
i have a column of numbers I also have a column of cells containing cell address ie N2, O2, P2 what i would like to do is loop through the numbers read the number if it is 1 i would like to copy the contents of N2 and paste it into O2 and P2 N2 being the first row of data as we loop through the number will change ie N7, o7,P7 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use cell address
On Jun 23, 6:27*am, kevcar40 wrote:
Hi i have a column of numbers I also have a column of cells containing cell address ie N2, O2, P2 what i would like to do is loop through the numbers read the number if it is 1 i would like to copy the contents of N2 and paste it into O2 and P2 N2 being the first row of data as we loop through the number will change ie N7, o7,P7 Reply to my personal email to you about the logic of what you are doing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) |