+ Reply to Thread
Results 1 to 2 of 2

Copy values from adjacent cells to groups of adjacent cells with gaps

  1. #1
    Registered User
    Join Date
    06-14-2017
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2016
    Posts
    3

    Copy values from adjacent cells to groups of adjacent cells with gaps

    Hello! I am in desperate need for some help...

    -On one sheet 1 I have a list of adjacent cells with information.
    -On sheet2 I have reports divided up into different pages.
    -I need to copy the reports down since there is a large number of them.
    -On sheet2 I need A10 to A39 to pull from sheet1 A4 to A33, and then I need sheet2 A57 to A86 to pull from sheet1 A34 to A63, then sheet2 A104 to A133 from sheet1 A64 to A93, ect.
    -I need a formula that will continue to pull from the correct reference cells on sheet1 when I copy all of the report pages down.

    Thanks

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,340

    Re: Copy values from adjacent cells to groups of adjacent cells with gaps

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-15-2017, 05:42 PM
  2. [SOLVED] How to copy value of adjacent cells to non-adjacent cells
    By mgoutam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2014, 04:35 PM
  3. Copy from no adjacent cells to adjacent cells
    By vkvkcy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2014, 04:06 AM
  4. Replies: 7
    Last Post: 12-04-2012, 06:23 AM
  5. [SOLVED] Help writing a macro to find text and copy values to adjacent cells
    By Nnnnnnnick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 10:07 AM
  6. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  7. Replies: 2
    Last Post: 07-09-2012, 09:21 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1