Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Consolidating entries from multiple worksheets
I am using Excel XP.
I have a spreadsheet with 5 worksheets, named Monday to Friday that I use to record details of visits that I make. Within each of these worksheets there is an area where I have the option to record comments about the visit. I want to create a sixth worksheet that consolidates these comments into one list so that they can be viewed at a glance. Of course I can reference each cell on the Monday - Friday spreadsheets, but this could leave a number of blank spaces where I have not made a comment. I guess I could write a macro that sorts the list and puts the blanks at the bottom, but if there is a function that will do it automatically, it would be preferable. Thanks for any guidance you are able to provide. |
#2
|
|||
|
|||
There's code here to copy comments to another sheet in the workbook:
http://www.contextures.com/xlcomment...ml#CopyToSheet Al wrote: I am using Excel XP. I have a spreadsheet with 5 worksheets, named Monday to Friday that I use to record details of visits that I make. Within each of these worksheets there is an area where I have the option to record comments about the visit. I want to create a sixth worksheet that consolidates these comments into one list so that they can be viewed at a glance. Of course I can reference each cell on the Monday - Friday spreadsheets, but this could leave a number of blank spaces where I have not made a comment. I guess I could write a macro that sorts the list and puts the blanks at the bottom, but if there is a function that will do it automatically, it would be preferable. Thanks for any guidance you are able to provide. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
multiple entries | Excel Worksheet Functions |