Looking to copy select cells in table using dropdown list to paste to new table in another worksheet

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet

FAQ

Thread Tools

Display Modes

12-21-2017, 11:50 PM

NoSparks

Windows 7 64bit Looking to copy select cells in table using dropdown list to paste to new table in another worksheet

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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

Attached Files

(1) DEMO Minnesota FY2018 GOE Tracker Workbook 12-21-17_v2.zip (1.47 MB, 13 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to paste the data from one table into the cells of another table, without overwriting anything	CClio333	Word Tables	1	08-12-2014 05:17 PM
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word?	Joey Cheung	Word Tables	1	08-12-2014 05:15 PM
Can you copy & paste cells across worksheets and preserve reference to worksheet?	New Daddy	Excel	2	11-27-2013 07:19 AM
Copy and paste table	Patrickjm	Word	1	03-19-2013 03:30 PM
Populate dropdown list with data from Access table	spw4000	Office	0	02-24-2012 05:22 AM