Thread: Looking to copy select cells in table using dropdown list to paste to new table in another worksheet
View Single Post
 
Old 12-21-2017, 08:21 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Quote:
However, when I tested other worksheets, such as 23370 and 26062, when "NO" is selected, only the description column is showing up on the MAIN GOE RECONCILIATION worksheet. No date or dollar amount. Any suggestions. When the "NO" column on the worksheets is removed, the description is removed, which is good. Any further tweaking needed on my end?
Check the columns being copied with the request of your original post.

I have no idea how those sheets are being populated but suspect it is by sheet reference rather than table reference.
The intermingle of sheet addresses with tables makes things difficult.
Reply With Quote