Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Populating data From one sheet to another, relative rows
Register FAQ

Reply
Page 2 of 2 1 2
 
Thread Tools Display Modes
  #16  
Old 02-05-2016, 09:30 PM
xor xor is offline Populating data From one sheet to another, relative rows Windows 10 Populating data From one sheet to another, relative rows Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Take a look at the formula in sheet BC, cell A4. You will note that the last argument of the INDEX-function has a "1" meaning that it takes a value from the first column in d (sheet Master). Now look at the formula in BC!B4 and note that it has "4" as the last argument of the INDEX-function meaning that it takes a value from column 4 in d, that is the column with Hours.
Reply With Quote
  #17  
Old 02-08-2016, 09:06 AM
mmp mmp is offline Populating data From one sheet to another, relative rows Windows 7 64bit Populating data From one sheet to another, relative rows Office 2010 64bit
Novice
Populating data From one sheet to another, relative rows 		 
Join Date: Feb 2016
Posts: 11
mmp is on a distinguished road
Default
Thank you for your help. I added a disposition array so the right colums would populate and all seems to be working now. Thank you so much for your help.
Reply With Quote
Reply
Page 2 of 2 1 2

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating data From one sheet to another, relative rows Setting autofilter criteria using columns and cells relative to the active cell in another sheet SarahL Excel Programming 7 06-11-2015 10:26 AM
Populating Data in New TABs? Sueade Excel 2 06-02-2015 09:12 PM
Populating data From one sheet to another, relative rows Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Populating data From one sheet to another, relative rows Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. rogcar75 Excel 3 08-28-2014 05:21 PM
Fix data output position relative to page Al See Mail Merge 1 01-16-2014 04:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft