Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Basic Question on autocomplete function

Hi everyone, my first time on the forum and my first thread. I apologize if this is already located on the forum here. I tried searching, but came up with many unrelated threads so I thought I'd give this a shot.

I am trying to auto complete a link to another worksheet by corner dragging a formula over a ROW in one worksheet FROM data in the COLUMN of another worksheet. In other words:

Worksheet 1: E9, F9, G9, should point to (respectively),
Worksheet 2: C2, C3, C4

The auto complete formula function does not recognize what I'm trying to do. And I have to do this with tens of thousands of cells. It would boil down to only a hundred rows or so if I could automate this.

Thanks for any help!

- excel noob -
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 464
Default Basic Question on autocomplete function

Based on your example;
=INDIRECT("'Sheet2'!C" & COLUMN()-3)



--
Regards
Dave Hawley
www.ozgrid.com
"kimmyhendrix" wrote in message
...

Hi everyone, my first time on the forum and my first thread. I apologize
if this is already located on the forum here. I tried searching, but
came up with many unrelated threads so I thought I'd give this a shot.

I am trying to auto complete a link to another worksheet by corner
dragging a formula over a ROW in one worksheet FROM data in the COLUMN
of another worksheet. In other words:

Worksheet 1: E9, F9, G9, should point to (respectively),
Worksheet 2: C2, C3, C4

The auto complete formula function does not recognize what I'm trying
to do. And I have to do this with tens of thousands of cells. It would
boil down to only a hundred rows or so if I could automate this.

Thanks for any help!

- excel noob -




--
kimmyhendrix


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 376
Default Basic Question on autocomplete function

Hi
As an alternative to Dave's suggestion, especially if there are going to
be a lot of formulae on the sheet, you could use the non-volatile Index
function.
Enter in E9
=INDEX(Sheet2!$1:$65536,COLUMN()-3,ROW()-6)
Copy across and down as required

--
Regards
Roger Govier

kimmyhendrix wrote:
Hi everyone, my first time on the forum and my first thread. I apologize
if this is already located on the forum here. I tried searching, but
came up with many unrelated threads so I thought I'd give this a shot.

I am trying to auto complete a link to another worksheet by corner
dragging a formula over a ROW in one worksheet FROM data in the COLUMN
of another worksheet. In other words:

Worksheet 1: E9, F9, G9, should point to (respectively),
Worksheet 2: C2, C3, C4

The auto complete formula function does not recognize what I'm trying
to do. And I have to do this with tens of thousands of cells. It would
boil down to only a hundred rows or so if I could automate this.

Thanks for any help!

- excel noob -




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
excel 2002 question for pick from list with autocomplete function Morris Excel Worksheet Functions 1 March 18th 08 08:26 PM
Another Autocomplete question! itsbeal Excel Discussion (Misc queries) 1 December 31st 07 04:53 PM
Do dropdown lists have an autocomplete function? thg Excel Discussion (Misc queries) 2 August 7th 05 10:14 PM
Autocomplete function Drsally Excel Discussion (Misc queries) 1 June 7th 05 03:29 PM
Autocomplete question marika1981 Excel Discussion (Misc queries) 3 March 7th 05 12:09 AM


All times are GMT +1. The time now is 02:40 PM.

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

About Us

"It's about Microsoft Excel"