Copy cell range from active sheet to all remaining sheets

[jpruffle]

Hi,

I have created a basic planner that runs for a number of years. Each sheet has range A1:B20 for example that has staff on. When the staff change I want all the sheets after the active sheet to copy this range from the active sheet. This would make sure all staff are updated after that month.

Is this possible?

Thanks,

JP

[davegugg]

Can you just put formulas in each sheet to the front sheet? For example, in each sheet Cell A1 put "=FrontSheet!A1".

[jpruffle]

Thank you for your reply. Sorry I didn't explain it very well.

At the start of the year the staff will remain the same no doubt for a few month but then as staff change I want those changes to be copied to all other worksheets after that month. So for example, staff change in March, sheets April, May, June etc wil get the copied staff list so any future leave etc can be added to save re keying. The old entries need to remain so that they can be referred to.

Any help would be appreciated.

Thanks,

JP

[davegugg]

I still think I'd do it with a link to a different sheet on each sheet, then once the month is completed just copy A1:B20 and pastespecial -> Values to get rid of the link.

However, if you want to use vba, this will copy those cells to each sheet after the active sheet:

Please Login or Register  to view this content.

[jpruffle]

Thank you for the reply.

Is there a way through VBA to do the copy and paste special (values) as described?

Thanks,

JP

[davegugg]

Please Login or Register  to view this content.