#1   Report Post  
Old June 23rd 11, 12:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 78
Default 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   Report Post  
Old June 23rd 11, 01:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, sarah Excel Worksheet Functions 2 February 17th 09 02:59 PM
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? sarah Excel Worksheet Functions 0 February 17th 09 02:06 PM
Return cell address of a cell based on contents of cell. Danny Excel Worksheet Functions 4 November 15th 08 03:11 AM
find last cell in range with data, display cell address sevi61 Excel Worksheet Functions 14 October 29th 07 08:36 PM
How make hyperlink refer to cell content rather than cell address. Omunene Excel Discussion (Misc queries) 3 March 2nd 06 01:07 AM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017