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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Kneigum in forum Excel General
Last Post: 06-15-2017, 05:42 PM
By mgoutam in forum Excel Formulas & Functions
Last Post: 10-22-2014, 04:35 PM
By vkvkcy in forum Excel Programming / VBA / Macros
Last Post: 09-19-2014, 04:06 AM
By srolash in forum Excel Formulas & Functions
Last Post: 12-04-2012, 06:23 AM
By Nnnnnnnick in forum Excel Programming / VBA / Macros
Last Post: 10-24-2012, 10:07 AM
By cajodonn in forum Excel General
Last Post: 07-30-2012, 11:20 AM
By swmwshrk in forum Excel General
Last Post: 07-09-2012, 09:21 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1