Good morning!
My grasp of VBA is extremely basic so I'm struggling to come up with a solution to this problem:
I have a workbook with two worksheets. The first worksheet (Sheet1) has a macro that imports data from an external data source. Including:
Cell H2 - week number eg. 1 to 52
Cell M2 - a unique identifier number - alphanumeric
Cell M27 - a numeric value
The second worksheet is a database of the above information. I can't use a formula as the data in Sheet1 changes.
What I'd like is a simple command button that looks up the week number and unique identifier and enters the value from cell M27 in the relevent place.
Thanks
Steve
Bookmarks