Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying row information in another file
I posted this over in misc, but no one was able to help me there. Maybe
here... I have been asked to create a worksheet (file 1) that displays selected table row information (row-by-row) from a second file (file 2). (The column data in file 2 is consistently located in each row, and information is a mix of text and numbers.) The row information in file 2 is extensive and management wants a worksheet in file 1 that displays only selected information. I have achieved this in file 1 using "=" to display cell information from each cell needed in file 2, and autoupdate works great. But, when a row in file 2 is deleted, the corresponding row in file 1 gets filled with '#REF'. I just want to display the information in each row from file 2 without worrying about '#REF' showing up in file 1 when a row is deleted. Is this possible? Or, am I stuck with getting '#REF' from deleted rows. Unfortunately, rows must be deleted from file 2 and I have to work with separate files. Thanks. Jeff |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying row information in another file
Hi Jeff,
you could think about using Autofilters on file 2 to select the data you want to be displayed. You can then highlight all the visible data, click <copy, then paste it to the other (blank, but formatted) file - only the visible cells will be copied across. You could record a macro while you do this, so that in future you can just re-apply the macro to extract the data that you need. Hope this helps. Pete On Mar 19, 3:55 pm, "Jeff Weinberg" wrote: I posted this over in misc, but no one was able to help me there. Maybe here... I have been asked to create a worksheet (file 1) that displays selected table row information (row-by-row) from a second file (file 2). (The column data in file 2 is consistently located in each row, and information is a mix of text and numbers.) The row information in file 2 is extensive and management wants a worksheet in file 1 that displays only selected information. I have achieved this in file 1 using "=" to display cell information from each cell needed in file 2, and autoupdate works great. But, when a row in file 2 is deleted, the corresponding row in file 1 gets filled with '#REF'. I just want to display the information in each row from file 2 without worrying about '#REF' showing up in file 1 when a row is deleted. Is this possible? Or, am I stuck with getting '#REF' from deleted rows. Unfortunately, rows must be deleted from file 2 and I have to work with separate files. Thanks. Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying the same information every week in different cells and preserving data. | Excel Worksheet Functions | |||
Information in Mutiple Workbooks Not Displaying in my Recap Sheet | Excel Discussion (Misc queries) | |||
Subtotals not displaying information properly: Excel 2003 | Excel Discussion (Misc queries) | |||
Displaying summary information in a workbook | Excel Discussion (Misc queries) | |||
Displaying YTD totals as you populate monthly information | Excel Worksheet Functions |