Should be straightforward, but can't see why it's going wrong!
As shown in sample attached.
User receives new version of drawing (e.g. Version AS).
Enters date received into next free column in Date Headers in row 6 (Cols D - S in the sample), finds the row for the Drawing Number (Row 7 in sample), and adds Version number in same Column as date.
To add the new record to Database, enters Y in Col AD of row.
With AD7 as the "active cell", Macro needs to search the "Date" range of the record (D7 - S7 in sample), "find" the last column in it with data (Col H in sample) and copy the date in row 6 to next free row in Database Col A.
Problems:
(a) Macro is not recognising Col H as the last "used" column in the "Date" range
(b) Code copying date to Database generates a RunTime Error 1004
All solutions, suggestions and alternatives welcome as everPlease Login or Register to view this content.
Ochimus
Bookmarks