A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Links and Linking in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Help with referencing from a list of numbers on another sheet please!

Thread Tools Display Modes
Old May 7th 14, 09:49 AM
SammyBoy85 SammyBoy85 is offline
Junior Member
First recorded activity by ExcelBanter: May 2014
Posts: 1
Default Help with referencing from a list of numbers on another sheet please!

Hi Folks,

I have a problem which I am sure there is a simple soultion for but I can't for the life of me work it out.

I have a workbook (Workbook 1) which has been completed with a list of numbers starting in B16. In a seperate workbook (Workbook 2) I would like to reference to these numbers and autofill the cell references down increasing the Cell reference by 1 but the actual cell that this reference will appear in will have jumped down several rows.

For Example:
Workbook 1 Workbook 2
B16 C10 = Workbook 1 Cell B16
B17 C20 = Workbook 1 Cell B17
B18 C30 = Workbook 1 Cell B18
B19 C40 = Workbook 1 Cell B19

The number of cells missed out on the reference workbook would be consistant, say 10 cells like in the example.

I have several thousand of these references to do so you can understand that I don't want to manual enter each reference.

Thanks in advance for your help

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross referencing a weekly menu list with a grocery list mpatel6 Excel Discussion (Misc queries) 1 March 6th 13 06:13 PM
Referencing Sheet names/numbers Ron[_32_] Excel Programming 3 April 21st 08 05:47 PM
referencing a different tab by referencing a list in the current s Kevin Excel Worksheet Functions 3 July 6th 07 07:57 PM
Referencing Numbers pugsly8422 Charts and Charting in Excel 2 January 31st 07 07:22 PM
referencing a sheet named in a cell then using data from that sheet gbeard Excel Worksheet Functions 4 April 15th 05 08:42 AM

All times are GMT +1. The time now is 10:15 AM.

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