Populate a form-like dashboard using data from a spreadsheet.

ewenardus

New Member
Joined
May 19, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi all!

I have info in a spreadsheet that relates to monthly reports of different Projects:

1621455520522.png


And I need to show this data in a more friendly sort of form-like way:

1621455597451.png


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?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
This is a case of wanting someone else to develop an app for free. What you want to do is very doable and there is a lot of information on various forums to help develop this but asking for someone to do it for free is not appreciated.
 

ewenardus

New Member
Joined
May 19, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Sorry you read it like that - never expected someone to develop an app for me for free, just wanted to be pointed in the right direction with this. I spent quite some time trying to solve this on my own first, and as I didn't come across a solution I posted my querry. If you could just point me towards those forums you mentioned I'll manage from there: the thing is I don't even know how to call this that I need. Again sorry.
 

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
I recommend as a first effort to google search for "Excel VBA Dashboard". Then check out some of the links there. I will be willing to help "coach" you as you find things that might work for you. How conversant are you with VBA?

I apologize for the tone of my post earlier. We want to help but when there is very little info to go on it is very hard to even "point you in the right direction".

As an aside, note my signature line below. I have operated by that sentiment for almost 40 years.
 

ewenardus

New Member
Joined
May 19, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

No problem, and thanks for the advice. I'll check that out - not very conversant with vba but I'll see what I can manage. Cheers!
 

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
Again, I will gladly work with you as needed.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,520
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
It doesn't look like an actual form......Is it simply a range of cells setup to look like a Form / dashboard ??
To populate cells on the "Form" you would need to provide much more information.....
Sheet names, cell ranges, how you want them to change, etc.
I'd suggest either using the XL2BB link in my signature to share real data OR upload the file to a hosting site, ie, DropBox for instance, then post the link back here for other posters to provide input and assistance......but we would still need the previously mentioned infromation
 

Forum statistics

Threads
1,136,278
Messages
5,674,807
Members
419,526
Latest member
ranjit446

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top