Changing Cell address within a formula

		Microsoft Office Forums > Microsoft Excel > Excel
Changing Cell address within a formula

FAQ

Mark Forums Read

Thread Tools

Display Modes

#10

09-21-2012, 01:46 AM

Pecoflyer

Windows 7 64bit Changing Cell address within a formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Your sheet does still not show what you want to achieve , only the result of my suggestion which is not what you need

Is it

Code:

=INDIRECT("sheet1!A"&((ROW()-1)*4)+1)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keep cell in formula constant	jprt68	Excel	1	06-26-2012 08:31 AM
Changing cell leftpadding moves whole table	kae0088	Word Tables	1	05-12-2012 11:25 PM
need to check whether cell contains formula	etodem	Excel	2	10-23-2010 07:33 PM
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM
Code for Changing Cell Backgrounds	leroytrolley	Excel	2	12-05-2008 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:46 PM.