Automatically add rows/columns on second sheet when I add row/column to first?

[taketwo]

I am using "Excel 2003", and am almost out of columns (I've used 237 out of the possible 256). I will probably have to split it up into two sheets, but would have to figure something out first:

On the left of my current sheet is a list of all of the jobs we are working on (along with the dates we worked on them), and then going across the top is a list of all the different duties we can perform, all of our employees, all of the vehicles we own, all of the different equipment we use... basically, everything that goes into doing the physical work. Each row represents a day at a job ("Appletown 1/1/09", "Appletown 1/2/09", "Bananaville 1/1/09", etc.), and then I run across the row, filling in info as I go (which duty was performed, which employees went to that job, which vehicles and equipment were used).

As I said, the table is growing too wide, so I would like to divide it into two sheets - I'd like to keep some of the info (duties, employees) on one sheet, and then move the rest of the info (vehicles, equipment) on the second sheet. My concern is that, if I were to add a row on the first sheet ("Appletown 1/3/09"), that row wouldn't automatically be added to the second sheet - I'd have to manually enter the row. Not a big deal for a row or two, but I add many rows a day, and don't want my totals getting messed up.

Would there be a way to do that? Thank you in advance for any help.

[martindwilson]

it would really be better if you put the jobs and dates along the top starting new columns / new sheets us needed and all the things you do down the rows
you could highlight all the data used so far well the first 256 entries (then repeat on another sheet and so on for each 256 chunk)
copy
then in a new sheet select cell a1
paste special transpose
now all the stuff will be laid out the otherway around.

[taketwo]

That's not a bad idea, actually - I didn't want to do that initially, since that would mean not having all of the jobs together, but I could set-up a separate page for each section of job-numbers (a sheet for our "100" jobs, "200" jobs, etc.).

I still would have a similar problem, though - even if I transpose the data, I would still need to have rows added automatically; if we hire a new employee or buy a new piece of equipment, I'd like to be able to add a row to the first sheet, and then have that row automatically added to each sheet.

I mean, ultimately, it's not a big deal to do it manually, but I don't want to worry that I might forget one.

Thanks for the help.

[martindwilson]

youd need code to add that row, ask in the programming section
"code to mirror/repeat inserted row/rows across multiple sheets"