Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cell locations

Hi All....
I would like to enter a cell's location (say A1) and then based on that data
creat a way to pull info from a cell 1, 2, 3... etc. cells to the right.
Example target cell is A1 and I want value from A2 without just entering =A2.
Reason for this is I need the value from 150 different cell but only 30 at a
time.
 
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
Manipulating a column array into different cell locations Joe Excel Discussion (Misc queries) 5 April 14th 07 10:29 PM
AutoFill pattern based on cell locations valoo Excel Discussion (Misc queries) 4 July 28th 06 09:39 PM
Changing cell locations with formula? Trevor Excel Discussion (Misc queries) 1 June 29th 06 02:57 AM
Can CELL Return Multiple Data Locations? Val Excel Worksheet Functions 3 May 18th 06 02:35 AM
InputBox to select cell locations Michael M Excel Worksheet Functions 5 February 21st 06 05:18 PM


All times are GMT +1. The time now is 06:59 AM.

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

About Us

"It's about Microsoft Excel"