Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old May 7th 14, 09:49 AM
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

Reply
Thread Tools
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
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 06:24 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017