Hi,
I have the attached file as an example.
In the sheet "RawInput"... i have the relavent data which i need updated(Column A:F) and the data that i am updating is in column K:M.
I would like:
- An input box which ask's me to enter a date or multiple dates
- I would then like the macro to look up in column L and see if there is any data for that date. e.g I put in the date "19-01-2009"...
With this data, i would like it to copy all the "Cat" + "Changed On" + "CountOfChangeOn" for that date and insert it in Column A:C in Row 2.
The sheet "Result" is the final result.
How can i go about implementing this because i am trying to automate this etc..
Thank You
Bookmarks