Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-27-2016, 12:21 PM
friesjh friesjh is offline Linking Range of Cells in a Row Windows 10 Linking Range of Cells in a Row Office 2013
Novice
Linking Range of Cells in a Row
 
Join Date: Jun 2016
Posts: 2
friesjh is on a distinguished road
Default Linking Range of Cells in a Row


I have two spreadsheets in a workbook. One is "Master Sheet", the other is "Short Sheet". Like it implies the master sheet has all the pertinent information . The short sheet has information I need at a glance. As I populate the master sheet I would like it to automatically populate the short sheet. The problem being, I want cells A-L in every fifth row to be linked to the short sheet from the master sheet. I had it setup to link just those columns to the short sheet, but that is way too much information. That included the 4 rows of information I really don't want on my short sheet. I tried setting up the first few rows by hand, then dragging down to continue the formulas to following cells, but Excel did not recognize the pattern of every 5th row. Any suggestions?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Range of Cells in a Row Format a range of cells Dave T Excel Programming 1 06-01-2016 08:58 PM
Linking Range of Cells in a Row Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Linking Range of Cells in a Row Linking cells that also contain text jhamblin Excel 1 02-20-2015 07:43 AM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

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


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