I’m not sure what type a problem this is (lookup table, progressive IF statement, VBA, or other issue) but I thought I’d start here. If this should be posted elsewhere, please let me know.
We have an Excel spreadsheet that tracks our timecard activities. We’re in the process of moving all payroll items to our new system financial software which means all tracking will be done inside the new app not Excel. However, the spreadsheet works so much easier. What I want is to update an Access table from Excel. This gets a bit confusing but I’ll try to explain my problem.
I’d like to update a cell in one worksheet (DATABASE) based on info from another worksheet (TIMECARD). I have a routine from a kind sole here, that creates a list of rows in DATABASE based on dates entered TIMECARD. Now I need to add a couple additional cells for the PROGRAM and ACTIVITY data. If an entry is made for a date in TIMECARD, then I’d like the PROGRAM and ACTIVITY cells in DATABASE to include that entry for the line corresponding to that specific date.
I have attached an extremely slimmed down version of my spreadsheet showing what I have in mind.
In the old Lotus 1-2-3 days, I could have solved this with “keystroke macros”, but now with VBA, I’m totally lost. Any suggestions would be greatly appreciated.
Thanks,
Steve Kipping
Bookmarks