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, 11:50 PM
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
Okay, here's your file back. Don't think I can do much more than this. Should work now writing to and removing from the tables
on the "MONTHLY GOE RECONCILIATION" sheet.

Added an ID column to end of each of the 24 tables (via macro in NoSparks module) that's required for removals.
Altered the amount cell to be written to the tables for the 'other' sheets from J to I.

Good luck with the project.
NoSparks
Reply With Quote