|
|
Thread Tools | Display Modes |
#16
|
|||
|
|||
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 |
#17
|
|||
|
|||
I will check it out.
Thanks much! |
#18
|
|||
|
|||
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, |
#19
|
|||
|
|||
Quote:
Quote:
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. |
Thread Tools | |
Display Modes | |
|
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 |