Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 12-21-2017, 06:51 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

Good morning - In response to your question, once I enter information into the Procurement Log and hit the UPDATE button, it automatically populates the data into the respective worksheet (either 23370 Telephone Services or 26062 Supplies). These are the only two classes that procurements are made to.

I checked and it appears that all required data cells are populated to the MAIN GOE RECONCILIATION from the 21000 State Program Travel worksheet when "NO" is selected. It also looks like when I "clear" the "NO" out the data is removed from the MAIN GOE RECONCILIATION worksheet. Just what I needed!

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?

Thanks again -

Last edited by CaptainRetired; 12-21-2017 at 06:52 AM. Reason: Spelling
Reply With Quote
 



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 08:46 PM.


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