How to share rows between excel sheets?
Is it possible to have one sheet reference another sheet to populate an entire row?
We are working on a file in Excel 2010 for a schedule that has one master schedule sheet (tab1) and then a daily sheet including other data. What we are trying to do is connect Tab1 Rows to appear on Tab2 or Tab3. We would like to be able to update Tab1 Master sheet and have it populate the other sheets that it is connected to. We understand how to do this for individual cells using the = function, but we are unsure how to do this by row.
Attached document as a reference to follow this example:
We would like Master Schedule Sheet Row 38 to appear on Sheet 7/5 Thursday Row 6. This would allow us to make changes on the Master Schedule that would automatically update the 7/5 Thursday sheet.
Is this possible?
Thank you!
Melissa
| Attachment | Size |
|---|---|
| VOLUNTEER NEEDS ASSESSMENT_ForHelpDesk.xlsx | 179.51 KB |
Hi Melissa... I think you're
Hi Melissa... I think you're creating a lot of problems for yourself with this design of spreadsheet as there is no clear separation between data input, data storage, and reports. However, if you don't know VBA, it's tough to structure your sheet well. If you end up in a mess, we'd be happy to help simply Request a Quote.
If you're determined to go down your current route, I can advise that you can create a formula to replicate a row on your master sheet.
conceptually, if you were to replicate Row 1 for example...
Enter this in the first cell of the sheet to be copied:
=IF('MASTER SCHEDULE'!A1<>"",'MASTER SCHEDULE'!A1,"")
then copy that formula across for the whole row.
NOTE: this will increase your file size so you might want to only copy the formula for as far as there is data.