Microsoft Office Help

[General Zod]

okay. . . .i'm creating a project for something in Excel, but i'm a tad stuck. is there any way to make a function that lets certain columns be repeated over various tabs according to certain criteria?

for example, i'm making a roster of players on a team and want to make each tab a roster per each year. in order to make it so that i don't have to type each entry manually, is there a function i can use to make it so that certain frames/numbers/etc. copy over to each tab? ie - the years a certain player was in copies over to the tab labeled for that year? if so, how? any help would be appreciated.

[Rogue 9]

Yeah. Your basic copy/paste. You copy the contents of a cell like you would a sentence on the board or in a Word document, highlight all the cells you want that entry in, and paste. It'll show up in all of them.

[General Zod]

well, not exactly what i had in mind. . . .lemme try something a bit more visual.

[tab 1] [yy] [yy]

dd/yy/mm dd/yy/mm dd/yy/mm

basically, what i'm hoping for is typing numbers into the first tab, and then have them show up in the relevant tabs. each tab would represent a specific year, then i'd have certain columns set up for the years those players were in. i was hoping to have a function beyond copy and paste i could use to make it so that the information from the year they're in automatically copies itself into the relevant tab. if that makes any sense whatsoever. . . .it's alot harder to put it into words than visualize it.

[Rogue 9]

Ah. I tend to work with databases more than Excel just because I can. I'll go mess around with Excel some and see if I can figure something out.

[phongn]

If you, say, have the value "GREEN" in cell A1 and want E2 to act as a pointer to A1, make E2's valie to be =A1 . Whenever you update A1, E2 will also be updated.