Populating data from another sheet from list then clearing after viewing

SausaG

New Member
Joined
Nov 13, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,

So I have an interesting problem, I am making a maintenance list for many machines and tools. I would like the first sheet of my workbook to be the only visible sheet in the workbook and everything else to be hidden.
I have already made it so I have another sheet that is a so called data-entry sheet (named "MALLI_LUOMINEN", it is also a blank "form" like the first sheet. You fill it up with the information about the machine and repairs that have been done to said machine already and press "Syötä" and it makes a new sheet that copys the data-entry sheet but names it according to the name of the machine that is specified in the "form". It also clears the data from the data-entry sheet so you can immediately create another one. But this is to be done only by me and not by other users so it is to be hidden.

MALLI-LUOMINEN.JPG

In the first sheet (ETUSIVU) that would be the only visible sheet (pictured below) I would like to populate it from the other sheets that have been named already after creating them in the data-entry sheet. I added a ComboBox to the first sheet that would be the drop down list of all of the machines and tools I have created a "form" for. After selecting a machine or tool I would like the data from the source sheet to populate the cells in the first sheet for viewing. I would also love the ability to add to the list of performed maintenances from the first sheet but it would also update it to the source sheet.

ETUSIVU.JPGCODE.JPG

This is the part I am stuck with and cant think of whats the best way to do this.

I did also add a sheet that contains a running list of created and named sheets named (LISTA) but i am not sure if it is useful. It automatically adds the name to the "A" column.

LISTA.JPG

I am not sure if this is the smartest way of doing this but if anyone has better ideas I am open ears!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,569
Messages
5,770,908
Members
425,651
Latest member
Mark Cashin

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