Hijrofoyle
New Member
- Joined
- Oct 7, 2002
- Messages
- 35
hey hey, say that i wanna take cells a1:a10 and make them each equal, say C10 + n*D11 where n = 1:10
any ideas?
-Hijrofoyle
any ideas?
-Hijrofoyle
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
incremental addition
- Thread starter Hijrofoyle
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Formula in A1 is:
=C$10+(ROW(A1)*D$11)
and copy down.
=C$10+(ROW(A1)*D$11)
and copy down.
Upvote
0
stevebausch
Well-known Member
- Joined
- May 11, 2002
- Messages
- 810
I think you did a good job defining your goal; I am just a bit distracted this morning.
Take a look at Paste-Special; you may find what you need.
Take a look at Paste-Special; you may find what you need.
Upvote
0
