Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 12-21-2017, 11:50 PM
NoSparks NoSparks is offline Looking to copy select cells in table using dropdown list to paste to new table in another worksheet 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: 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
  #17  
Old 12-29-2017, 11:28 AM
CaptainRetired CaptainRetired is offline Looking to copy select cells in table using dropdown list to paste to new table in another worksheet Windows 10 Looking to copy select cells in table using dropdown list to paste to new table in another worksheet Office 2016
Novice
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet
 
Join Date: Dec 2017
Posts: 11
CaptainRetired is on a distinguished road
Default

I will check it out.
Thanks much!
Reply With Quote
  #18  
Old 01-04-2018, 02:17 PM
CaptainRetired CaptainRetired is offline Looking to copy select cells in table using dropdown list to paste to new table in another worksheet Windows 10 Looking to copy select cells in table using dropdown list to paste to new table in another worksheet Office 2016
Novice
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet
 
Join Date: Dec 2017
Posts: 11
CaptainRetired is on a distinguished road
Default

NoSparks - Thanks for your help on this project. One question I need answered. I looked at your coding on the unhide rows etc. and need to know what can be changed to allow rows with data to remain visible in each sheet. Before, I had written formula to transfer relevant data from Procurement Log to either the 23370 or 26062 page, depending on what was selected in column H on the Procurement Log. The data is there, but is not visible until I open the filter. Before, this data was automatically populated and visible when I hit the UPDATE button, but now it does not show anything. Is it something in the code you wrote that I can fix. I need the data on all sheets to be seen without having to open the filter, if there is data on that worksheet.. Someone could bypass info on the respective table if they don't remember to open the filter.

This should be last question to you on this, as the only thing not working on the spreadsheet.

Thanks,
Reply With Quote
  #19  
Old 01-04-2018, 07:22 PM
NoSparks NoSparks is offline Looking to copy select cells in table using dropdown list to paste to new table in another worksheet 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: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
Is it something in the code you wrote that I can fix.
Nope, my coding doesn't touch the individual sheets, just reads specific cell values into an array.

Quote:
Before, this data was automatically populated and visible when I hit the UPDATE button, but now it does not show anything.
Anything you had before, you still have.
And you sure have a lot of empty code modules.... maybe deleted something you needed?

Last edited by NoSparks; 01-04-2018 at 11:42 PM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet 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
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft