+ Reply to Thread
Results 1 to 4 of 4

Cell Reference with Irregular Spacing

  1. 04-19-2016, 10:06 AM #1
    ej4443
    ej4443 is offline
    Registered User
    Join Date
    12-18-2014
    Location
    Missouri
    MS-Off Ver
    2010
    Posts
    2

    Cell Reference with Irregular Spacing

    Hello, I am working on an excel document where I need the information from sheet2 on sheet1. The issue I am having is the information on sheet 2 is spaced out starting at 7 and then a pattern of 10 increments after that; I need it all together on sheet1 with no spacing. Below is how I need the information displayed:

    sheet1!F5 = sheet2!D7
    sheet1!F6 = sheet2!D17
    sheet1!F7 = sheet2!D27
    sheet1!F8 = sheet2!D37
    sheet1!F9 = sheet2!D47
    sheet1!F10 = sheet2!D57
    etc.

    Let me know if you need any additional information! Thanks!
    Reply With QuoteRegister To Reply
  2. 04-19-2016, 10:29 AM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Cell Reference with Irregular Spacing

    Try this macro: 
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 04-19-2016, 12:53 PM #3
    ej4443
    ej4443 is offline
    Registered User
    Join Date
    12-18-2014
    Location
    Missouri
    MS-Off Ver
    2010
    Posts
    2

    Re: Cell Reference with Irregular Spacing

    Thank you! Exactly what I needed
    Reply With QuoteRegister To Reply
  4. 04-19-2016, 12:54 PM #4
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Cell Reference with Irregular Spacing

    You are very welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to speed up populating cells with irregular cell formulas, which have a set pattern?
    By RGM1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2016, 02:37 AM
  2. regular cell reference increment from irregular worksheet
    By moronmark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2011, 06:47 PM
  3. Excel 2007 : Choosing cell from irregular interval
    By shinizaki in forum Excel General
    Replies: 2
    Last Post: 10-05-2010, 08:39 AM
  4. Rows Spacing, Column Spacing
    By Pukka83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2008, 12:05 AM
  5. Cell Spacing
    By omekoiks in forum Excel General
    Replies: 1
    Last Post: 01-22-2007, 03:03 PM
  6. [SOLVED] line spacing in cell
    By dlh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-24-2006, 11:15 AM
  7. [SOLVED] Cell Spacing
    By Greg B in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1