1. main@jfw.groups.io

moderated Re: Grouping worksheets 2016

Paul Hunt <prhunt1@...>
 

Hello. The correct term is Linking.
I have a budget workbook with an income worksheet, a cash flow worksheet and an allocated spending plan worksheet.
When my income changes in my income worksheet, it changes on my cash flow plan and allocated spending plan worksheet.
Here is how it works.
Cell B7 on my income worksheet contains my income.
I need my income to be in cell c46 of my cash flow worksheet so I enter the formula =income!b7 in cell c46.
I also need my income to be in cell d3 of myallocated spending plan worksheet so I enter the formula =income!b7 in cell d3.
I hope that this helps.
Paul

On May 9, 2018, at 8:14 PM, HH. Smith Jr. <josham129@gmail.com> wrote:

Hi,

What I mean is, when you make a change to one worksheet it affects all the
worksheets in the given work sheet group or grouping sheets to make global
changes in the workbook.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Wednesday, May 9, 2018 8:11 PM
To: main@jfw.groups.io
Subject: Re: Grouping worksheets 2016

I'm not sure what you mean by grouping worksheets. Yu can rename and
reorder than using alt+h, then o, then r to rename and alt+h, then o, then m
to move them.
At 06:40 PM 5/9/2018, you wrote:
Hello fellow listerrs,

Does anyone has an easier way to group work sheets. I'm trying to
make monthly workbook and I want to group all the months. Any help
appreciated.
Join main@jfw.groups.io to automatically receive all group messages.