Excel help please

Murtle

Hi Guys

I am trying to create a workbook in excel that works as follows;

I have a list of name in the first spreadsheet, then the next tab I have details for this month, then the next tab I have details for the next month - but that they can see the names from the first tab each time.

Does this make sense??

Thanks heaps

M

bingo_bango

AFAIK, you can't do this. The only way would be to have a separate column in each tab (by which I assume you mean worksheet) for the names.

maforduk

Sorry, makes no sense!
I'll send you a PM.

maxamos

When I required some excel assistance I was pointed to this site

you have to sign up but the help you get is great

http://www.ozgrid.com/forum

There are also alot of knowlegable people on here who seem to be able to sort most things out.

Hope you get it sorted

Max

Chippy_Minton

You haven't said why you need to see the names on each month worksheet.

Do the names relate to the rows on each month worksheet? If so, you could display the names by having a separate column on each month tab (worksheet) which references the names. For example if the names are on a sheet called Names and the first name is in cell A2 then each month worksheet could display that name by specifying =Names!A2, then =Names!A3 etc.

Alternatively, you could have a userform which opens on each month worksheet and simply displays the names from the Names worksheet on the userform. Set the ShowModal property of the userform to False and then you can switch focus between the userform and the worksheets.

maforduk

I have asked her to e-mail me after I PM'd him/her.
No response.

I have helped previos people out with spreadsheets on here to total satisfaction. I think she worked for the MoD regarding Time Sheets and payroll.

Murtle

Hi Guys

Sorry I haven't had a chance to reply on her. No I don't work for the MOD I need to empty some PM's so I can reply which I have been doing. I have a copy of a document that is done how I need it, but I need to replicate it so have been trying to unpick it to work it out and using the link that maxamos gave to try and work it out.
Thanks for your help though I'm still around trying to get through step by step, due to the information in the document I'd rather not send it out as it is company confidential (no not the MOD....) but thank you for the kind offer.

M

maforduk

No, I didn't mean that you worked for the MoD. I meant that the other person I helped with Excel and sent me the document worked for the MoD.