PDA

View Full Version : How to group all sheets by default



puttu_rps
01-11-2009, 10:46 PM
Hi ,

I want to know how to group all the sheets by default (all the time). Becasue couple of things which each user udpate those details which needs to be carry overed for all the sheet by default.

Is there any setting so i can set grouping by default??

Please help me.

Thanks
Puttaswamy

GTO
01-12-2009, 12:58 AM
Greetings Puttaswamy,

I see that this is your first post and you just recently joined. Let me say "Welcome!" to you and let you know that you will 'meet' some very nice and helpful folks here :-)

Now as to your question, I am not sure what you mean exactly. Are you looking for the sheets to be arranged (left to right) in a certain order? Or (and it looks more likely) are you looking to have certain data automatically updated to a number of sheets/cells when said data is entered in one location.

It would help us help you to provide more details or attach an example workbook (no private/company info included) with some data and what's wanted.

I'm sure you will be able to get some great help, and again, welcome.

Mark

puttu_rps
01-12-2009, 12:52 PM
I have couple of workbood having same data. If i enter the information in one workbook it should be udpated for all the work book?

Please let me know how it can be change or update for all the workbooks?

May it will be same excel or different excel.

let me know if you required any more details.

Thanks