Hey Guru's,
I have a question for everyone who knows excel a lot better than me, which mostly all of you haha.
I want to create an excel spreadsheet which will act like so:
Sheet 1 has a list of all the applications that I have on my computer:
For each row, I would like to have a new sheet automatically created. So for example. I have 5 rows, should have a total of 6 sheets (6th is the first main one Sheet 1).Please Login or Register to view this content.
Also, on Sheet 1, I will have not only a list of all the applications but also information about it, like so:
For each row, I would like to have a new sheet automatically created, but also have the fields filled in according to a template that I want to design.Please Login or Register to view this content.
Pretty much I need Sheet 1 to be the main source of information, sort of a one stop shop to add/edit any information, and for the rest of the sheets to feed/update information from Sheet 1.
Can someone please advise if this is doable?
Bookmarks