hi to all... i am new on this forum... today is my frist day...
i need help from people who know work with excel but much better then i know now...
sorry for my bad english...
what i need is the next...
i have about 20 sheats in my excel, first sheet i called base, in that sheet must be all data from other sheets what i insert...
in base sheet i have 7 columns, in first column is the names, i have about 560 rows in that first column... and other 6 columns / rows must be linked to that first column... and what i need to do now... when i add data every day on my other sheets all columns / rows changing their place, can i somehow link all my other sheets to that first base sheet, because i must have calculations on that first sheet...
example:
this is base sheet
_A_________B_________C_________D_________E_______F_______G
John___29.7.2015____1 day____26.8.2015_____219____0.219____7.807
Mary___29.7.2015___3 days___26.8.2015______258____0.258____9.197
Peter___29.7.2015___5 days___26.8.2015_____224____0.2240____7.985
David__29.7.2015___4 days____26.8.2015_____232____0.232____8.270
Paul___29.7.2015____2 days___26.8.2015_____303_____0,303___10.801
now i must all this data put on other sheets, but i need on the first sheet see calculations of all other sheets i create... and if on other sheets some name is changed or added... that data must change on base sheet..
i hope so that someone will understand what i mean... its hard to me to explain...
i know only in excel all rows and columns can be monitor... but i dont know how to do that.. and if one sheet have on a1 have name John with all data in that row... and new sheet doesent have that name,excel can moitor all that and fill the blank rows... hmm... if someone cant understand what i need... you can ask me.. no problem i will try to explain better
thank you for your help...
Bookmarks