View Single Post
 
Old 12-21-2017, 06:51 AM
CaptainRetired CaptainRetired is offline Windows 10 Office 2016
Novice
 
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