ExcelBanter - Writing to 2 sheets at same time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Writing to 2 sheets at same time (https://www.excelbanter.com/excel-discussion-misc-queries/112428-writing-2-sheets-same-time.html)

drc

Writing to 2 sheets at same time

How do I write to 2 sheets at same time? Also:

On main sheet I have column of dates with other columns of data. I would
like to delete old data after a year. Thanks for any help.
drc

All times are GMT +1. The time now is 09:17 PM.