use cell address

K

kevcar40

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
 
D

Don Guillett

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
Click to expand...

Reply to my personal email to you about the logic of what you are
doing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop 1
allow multiple formulas in one cell 1
How to count with values from multiple columns? 5
Need a function to fill column from other columns 5
How to auto insert date in one cell when another is changed 2
Help required in merging two formulas into one 2
Easier way to concatenate a row? 8
combining multiple columns using ", " seperations.. 4

Top