Hi all!
I have info in a spreadsheet that relates to monthly reports of different Projects:
And I need to show this data in a more friendly sort of form-like way:
The data and form are both in the same workbook.
Each "form" should populate with the info from a specific row from the spreadsheet, and I would like to be able to change the info shown on the form simply by clicking a button. I imagine this is possible with quite a simple Macro, but I just haven't found one out there.
It would be a pluss if after populating the form with the required data for a specific project, I could then click another button to export that as an image or pdf.
The numbers in the A column in the spreadsheet would be my unique ID, as each project will complete there data monthly.
Anyone with any ideas?
I have info in a spreadsheet that relates to monthly reports of different Projects:
And I need to show this data in a more friendly sort of form-like way:
The data and form are both in the same workbook.
Each "form" should populate with the info from a specific row from the spreadsheet, and I would like to be able to change the info shown on the form simply by clicking a button. I imagine this is possible with quite a simple Macro, but I just haven't found one out there.
It would be a pluss if after populating the form with the required data for a specific project, I could then click another button to export that as an image or pdf.
The numbers in the A column in the spreadsheet would be my unique ID, as each project will complete there data monthly.
Anyone with any ideas?