moderated Grouping worksheets 2016
|
HH. Smith Jr.
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.
|
|
|
|
Ann Byrne
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.
toggle quoted messageShow quoted text
At 06:40 PM 5/9/2018, you wrote:
Hello fellow listerrs,
|
|
|
|
HH. Smith Jr.
Hi,
toggle quoted messageShow quoted text
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,appreciated.
|
|
|
|
Paul Hunt <prhunt1@...>
Hello. The correct term is Linking.
toggle quoted messageShow quoted text
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:
|
|
|
|
Mario
when using formulas as talked about here, can the following still be used:
toggle quoted messageShow quoted text
=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. .
|
|
|
|
Paul Hunt <prhunt1@...>
I’m not sure about that. Give it a try and let me know.
toggle quoted messageShow quoted text
On May 10, 2018, at 9:30 AM, Mario <mrb620@hotmail.com> wrote:
|
|
|
|
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.
toggle quoted messageShow quoted text
-----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: 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.
|
|
|
|
Chris Chaffin
Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location.
toggle quoted messageShow quoted text
One note, when moving the value, use cut and paste, or it will not work. Chris
On May 10, 2018, at 10:30 AM, Mario <mrb620@hotmail.com> wrote:
|
|
|
|
HH. Smith Jr.
Hi guys,
toggle quoted messageShow quoted text
Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin Sent: Thursday, May 10, 2018 1:23 PM To: main@jfw.groups.io Subject: Re: Grouping worksheets 2016 Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location. One note, when moving the value, use cut and paste, or it will not work. Chris On May 10, 2018, at 10:30 AM, Mario <mrb620@hotmail.com> wrote:m to move them.
|
|
|
|
CathyAnne Murtha
You can group worksheets that are next to on another with a keyboard command:
After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.
-----Original Message-----
Hi guys,
Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.
-----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin Sent: Thursday, May 10, 2018 1:23 PM Subject: Re: Grouping worksheets 2016
Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location. One note, when moving the value, use cut and paste, or it will not work.
Chris
> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> 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@...] > 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@...> 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. > > > > > > > > > > > > > > > > . > > > > >
|
|
|
|
HH. Smith Jr.
CathyAnne,
Thanks for the info.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of CathyAnne Murtha
Sent: Thursday, May 10, 2018 8:42 PM To: main@jfw.groups.io Subject: Re: Grouping worksheets 2016
You can group worksheets that are next to on another with a keyboard command:
After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.
-----Original Message-----
Hi guys,
Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.
-----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin Sent: Thursday, May 10, 2018 1:23 PM Subject: Re: Grouping worksheets 2016
Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location. One note, when moving the value, use cut and paste, or it will not work.
Chris
> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> 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@...] > 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@...> 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. > > > > > > > > > > > > > > > > . > > > > >
|
|
|
|
James Malone
Hi CathyAnne, Is your update to Office 2016 training books for sell? Best: James Malone
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of CathyAnne Murtha
Sent: Thursday, May 10, 2018 5:42 PM To: main@jfw.groups.io Subject: Re: Grouping worksheets 2016
You can group worksheets that are next to on another with a keyboard command:
After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.
-----Original Message-----
Hi guys,
Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.
-----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin Sent: Thursday, May 10, 2018 1:23 PM Subject: Re: Grouping worksheets 2016
Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location. One note, when moving the value, use cut and paste, or it will not work.
Chris
> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> 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@...] > 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@...> 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. > > > > > > > > > > > > > > > > . > > > > >
|
|
|
|
CathyAnne Murtha
Yes, you can find our textbooks at:
http://www.blind.training/ati-textbooks/
Happy weekend!
CathyAnne
CathyAnne Murtha Access Technology Institute, LLC (520) 300-7859
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of James Malone
Sent: Thursday, May 10, 2018 6:17 PM To: main@jfw.groups.io Subject: Re: Grouping worksheets 2016
Hi CathyAnne, Is your update to Office 2016 training books for sell? Best: James Malone
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of CathyAnne Murtha
You can group worksheets that are next to on another with a keyboard command:
After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.
-----Original Message-----
Hi guys,
Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.
-----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin Sent: Thursday, May 10, 2018 1:23 PM Subject: Re: Grouping worksheets 2016
Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location. One note, when moving the value, use cut and paste, or it will not work.
Chris
> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> 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@...] > 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@...> 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. > > > > > > > > > > > > > > > > . > > > > >
|
|
|