I need help on how to make excel template that allows list of each sheet input. My struggle is having to manually updates information to list from each sheet I make. As project goes on (3 years), it's hard to keep up tracking and ensure same information from sheets to list. List is like report. Sheet is what I use to work with specific groups to explain my proposal and feedbacks.
Scenario:
Each sheets have common template, just different information. For example, sheet 1 show an input to have $5. Sheet 2 have input of $10. Then I can switch to list, which shows rows of each sheet information and I can sum of total cost of $15.
Basically, on list, I can create new form for each row. On row 3, I select new sheet, then fill in information ($3). Then switch back to list and now I have 3 rows with information that sum of $18.
Other challenge is that each sheet have pictures of current condition and proposal that I want to show on list as well, which should be sync from sheet.
Anyone here know how to do that?
This template existed that I used from Japanese company, but the refused to disclose their macro process on how they do that, hah.
Bookmarks