ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create rows in excel so they show in all forward sheets? (https://www.excelbanter.com/excel-discussion-misc-queries/201431-how-create-rows-excel-so-they-show-all-forward-sheets.html)

sharon friedman

How to create rows in excel so they show in all forward sheets?
 
Hi I trying to create a worksheet where all data that you put in will repeat
in the following sheets and move the existing data so they are not written
over. It is a problem I didn't find in the books or online.

Thanks, Sharon


Dave Peterson

How to create rows in excel so they show in all forward sheets?
 
Excel isn't really made for this.

You could try using event macros, but it's going to be a big pain to implement.

If I had a choice, I'd put the data in one worksheet, then use filtering and
sorting to view/group my data.

sharon friedman wrote:

Hi I trying to create a worksheet where all data that you put in will repeat
in the following sheets and move the existing data so they are not written
over. It is a problem I didn't find in the books or online.

Thanks, Sharon


--

Dave Peterson


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com