ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   selecting cells in different worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/126445-selecting-cells-different-worksheets.html)

Kaitlin.uk

selecting cells in different worksheets
 
I am creating a workbook and i want to group different worksheets within that
book
e.g. group all that say 'November' in cell J1 & another group all that say
December etc etc

so that i can quickly see those worksheets instead of searching through all
the worksheets for the ones that say 'November'

does anybody have any suggestions on how i can do this? i would really
appreciate any help.

thanks

Dave F

selecting cells in different worksheets
 
I'm not really sure what you're asking, but here's a link on how to create a
table of contents for a workbook: http://www.mrexcel.com/tip017.shtml

Dave
--
Brevity is the soul of wit.


"Kaitlin.uk" wrote:

I am creating a workbook and i want to group different worksheets within that
book
e.g. group all that say 'November' in cell J1 & another group all that say
December etc etc

so that i can quickly see those worksheets instead of searching through all
the worksheets for the ones that say 'November'

does anybody have any suggestions on how i can do this? i would really
appreciate any help.

thanks


Kaitlin.uk

selecting cells in different worksheets
 
ok, I have a workbook with a lot of worksheets in it, one for each customer.
each customer pays a deposit. So on each sheet it will state the order date
in a cell and it will also state how much the deposit was in a cell.

is there anyway i could total how many deposits i received in, for example,
november.

thanks

"Dave F" wrote:

I'm not really sure what you're asking, but here's a link on how to create a
table of contents for a workbook: http://www.mrexcel.com/tip017.shtml

Dave
--
Brevity is the soul of wit.


"Kaitlin.uk" wrote:

I am creating a workbook and i want to group different worksheets within that
book
e.g. group all that say 'November' in cell J1 & another group all that say
December etc etc

so that i can quickly see those worksheets instead of searching through all
the worksheets for the ones that say 'November'

does anybody have any suggestions on how i can do this? i would really
appreciate any help.

thanks



All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com