[Solved] Manage repository datas by rows in multiple sheets

[helosourav]

helllo i am managing some product and its virson & mrp through different spreadsheet . i have created a REPOSITORY SHEET

repository sheet

i again created different sheets for different stores.

store 1 sheet

store 2

store 2 sheet

now i need a solutions by which when i do some change to any poroduct in the repository sheet the fields for the same products in the different store sheet should be updated dynamicaly.
and how can i add a product in other sheet so that its entire row also got into that sheet.
like if i add value '2' in the product number field , BETA 12.5 $2.00 will also get copied from the reprository
that entire row needs to be inserted.

store 2 sheet

[jrkrideau]

This is probably not the answer you want to hear but if you must use a spreadsheet it would be much better to have all the data on one sheet laid out as it is now but with one more column for a store ID.

Then you can do everything it appears that you need with a pivot table or set of pivot tables (aka data pilot). This layout allows you to slice and dice by any column or set of columns. It is far more flexible, less work and less error prone than trying to maintain multiple sheets.

[MrProgrammer]

now i need a solutions by which when i do some change to any poroduct in the repository sheet the fields for the same products in the different store sheet should be updated dynamicaly.

[Tutorial] VLOOKUP questions and answers

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[helosourav]

@jrkrideau thnx thats a nice idea,,, but i can do it for temporary ,because there are many othere parameters like product vendor / department that i need to fill in respective store.,... this vlookup is helpful i thing. @MrProgrammer

[jrkrideau]

@jrkrideau thnx thats a nice idea,,, but i can do it for temporary ,because there are many othere parameters like product vendor / department that i need to fill in respective store

This makes sense but it may be better to then put everything on one sheet once you have data set up.

A better solution is to use a data base for all of this. The problem is that setting up a data base is much more complicated and it has a difficult learning curve. The advantages are it is easier to maintain, there is far less need to data entry, a greatly reduced chance of errors and an overall more stable system.