updating sheet 2 from sheet 1 data

**robpd** · 01-05-2010, 01:01 PM

Hello!

I want to create two sheets of data with essentially the same information except sheet one should have data beginning the first of the year to present and sheet two data from july to present. I want to just update the first sheet and have changes be applied to sheet two when relevant.

I have a column with the date and rows are sorted from oldest to newest.

Is this possible? Can you please walk me through the steps to acheive this if so?

Thanks.

**Palmetto** · 01-05-2010, 01:43 PM

It's not entirely clear how sheet2 should be updated when sheet1 changes.

In order to quickly get a precise answer, it is best to upload a sample workbook that exactly duplicates the structure of your real workbook, contains a bit of representative (non-sensitive) data and manually shows what the expected/desired results should be.

**robpd** · 01-05-2010, 05:00 PM

Thanks for your response. It would be rather difficult for me to copy in my spreadsheet since it has multiple formulas and would require deleting a lot of sensitive data. Essentially it lists: client name, date of sale, product, revenue, client type, etc. It is sorted by date of sale. If I add a row for client X to sheet one, I want the exact same row added to sheet 2 if the sale took place after July 1. If I modify info in in sheet one for sales after July 1, I want those cells changed in sheet 2.

Does this make sense?