Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-15-2017, 07:19 PM
jrr95 jrr95 is offline Referencing different sheets Windows 10 Referencing different sheets Office 2010 64bit
Novice
Referencing different sheets
 
Join Date: Mar 2017
Posts: 1
jrr95 is on a distinguished road
Question Referencing different sheets

Hello.
I have a workbook with a LOT of sheets, labeled as dates(3-1-16, 3-2-16 ect.)
I have a master sheet that is pulling a specific cell from each sheet.


I need to be able to do something to automate the ever updating sheets, like right now each cell of the master sheet is something like ='3-1-16'!b$1' and each line I am typing in the name of the sheet each time. I need to be able to do like 1000 of these quickly and not have to copy down the ='3-1-16'!b$1' for the thousand and change each one to be the correct sheet name(date).
Any ideas?
Thanks!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to manage some sheets and sub-sheets? tesoke Excel 6 11-15-2015 04:54 AM
Referencing darksupernova Word 4 11-08-2012 03:37 AM
Multiple referencing SPRITEtoo Word 3 01-29-2012 07:39 PM
Linking sheets to fetch transactions from sheets to another waqer Excel 4 09-01-2011 12:35 PM
Cross referencing maltesedog Word 0 02-13-2009 07:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:48 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