moderated Re: Grouping worksheets 2016


Van Lant, Robin
 

I just tested it and it worked for my examples. If you have a cell on one sheet referencing a cell on a different cheat that you subsequently copy and move to another area or it is moved because you added columns or rows, then the cell reference on the first sheet will automatically update.

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Paul Hunt
Sent: Thursday, May 10, 2018 8:33 AM
To: main@jfw.groups.io
Subject: Re: Grouping worksheets 2016

I’m not sure about that. Give it a try and let me know.

On May 10, 2018, at 9:30 AM, Mario <mrb620@hotmail.com> wrote:

when using formulas as talked about here, can the following still be used:
=income!$d$4

meaning the linking to the value in d4 will still be referenced even
if the value has moved to d9 or e5?


-------- Original Message --------
From: Paul Hunt [mailto:prhunt1@att.net]
Sent: Wednesday, May 9, 2018 10:08 PM EST
To: main@jfw.groups.io
Subject: Grouping worksheets 2016

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.















.









This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@key.com with 'No Promotional E-mails' in the
SUBJECT line.

Join main@jfw.groups.io to automatically receive all group messages.