ManCityPete
New Member
- Joined
- Oct 30, 2015
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Apologies but this is actually a copy and paste question!
I am trying to update a spreadsheet inherited from a colleague. It's similar to a training matrix.
Each tab has a table containing a person's name on the row and a list of training courses along the columns.
For each course, there is a date that they did the training in one column, with a formula that determines the date based validity of the course in the next column. There could be up to 70 courses (60 columns) on each tab. There are upwards of 50 tabs. That's effectively over 3,000 columns of dates.
I have a new formula that I want to use next to each date.
Whilst it is very easy to select a column of formulae, copy it and paste it to the next formula column, there are over 3,000 columns.
With my knowledge, I can't copy and paste the who table because each table has dates specific to that course and that trainee.
Is there any way that I can copy the whole table and only paste the columns with formula in, so that the dates are not overwritten?
I know that I can copy alternate columns but when this is paste, they paste together, not in alternate columns.
Or is there a cleverer way to achieve what I want?
Dumb question, I can hear you saying already!!
I am trying to update a spreadsheet inherited from a colleague. It's similar to a training matrix.
Each tab has a table containing a person's name on the row and a list of training courses along the columns.
For each course, there is a date that they did the training in one column, with a formula that determines the date based validity of the course in the next column. There could be up to 70 courses (60 columns) on each tab. There are upwards of 50 tabs. That's effectively over 3,000 columns of dates.
I have a new formula that I want to use next to each date.
Whilst it is very easy to select a column of formulae, copy it and paste it to the next formula column, there are over 3,000 columns.
With my knowledge, I can't copy and paste the who table because each table has dates specific to that course and that trainee.
Is there any way that I can copy the whole table and only paste the columns with formula in, so that the dates are not overwritten?
I know that I can copy alternate columns but when this is paste, they paste together, not in alternate columns.
Or is there a cleverer way to achieve what I want?
Dumb question, I can hear you saying already!!