I have a spreadsheet and I need to update a table based on an entry in another worksheet.
Basically, a form which gets filled in weekly and needs to have that data stored by week in one big table on another worksheet.
I can do this the other way around (fill the form with data from the big table) with VLOOKUP statements but I'm guessing that I need some VBA/Macro code to do what I want?
I am fairly good with general excel stuff but when it comes to VBA I have learning to do
Oh and before anyone suggests it, using Access is not a solution (although this would be a doddle in Access!).
Basically, a form which gets filled in weekly and needs to have that data stored by week in one big table on another worksheet.
I can do this the other way around (fill the form with data from the big table) with VLOOKUP statements but I'm guessing that I need some VBA/Macro code to do what I want?
I am fairly good with general excel stuff but when it comes to VBA I have learning to do
Oh and before anyone suggests it, using Access is not a solution (although this would be a doddle in Access!).
Last edited:
