I'm making a system about calculating energy usage, for my ICT project, but I've gotten hopelessly stuck on one aspect.
In order to make the project as user friendly as possible, I said they could retrieve data with macros - I've discovered however that this is rather difficult.
So, it works like this
On one sheet, there's a list box, with a load of table names, the user selects a name, and presses a macro button that looks up the table, copies the information, and pastes it onto the current worksheet.
My problem is writing the macro to look up the appropriate table.
I worked out, that the code to looking up a table was
and I thought i could simply change the table name in the code to RefersToG12
It simply says the reference is invalid, and I'm utterly confused as to what to do.
Any help would be greatly appreciated.
In order to make the project as user friendly as possible, I said they could retrieve data with macros - I've discovered however that this is rather difficult.
So, it works like this
On one sheet, there's a list box, with a load of table names, the user selects a name, and presses a macro button that looks up the table, copies the information, and pastes it onto the current worksheet.
My problem is writing the macro to look up the appropriate table.
I worked out, that the code to looking up a table was
Code:
Application.Goto Reference:="_29_03_2011"
Code:
Application.Goto Reference:=RefersToG12
It simply says the reference is invalid, and I'm utterly confused as to what to do.
Any help would be greatly appreciated.