1
I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to manually copy all the values from Sheet1 to Sheet2. On the table of the Sheet2, I would do some filtering and sorting.
I am asking because I want to keep the amount of information visible to the use as minimal as possible. If a manager look at the spreadsheet, I want him/her to have a full view with all the calculation.
maybe a pivot table might be in order – chris neilsen – 2011-12-31T06:44:57.567
Have you been able to accomplish what you wanted with my instructions? – dnbrv – 2012-01-03T15:32:11.303