Results 1 to 1 of 1

Need help with excel data and plenty of sheets...

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2015
    Location
    Croatia
    MS-Off Ver
    2010 / 2013
    Posts
    1

    Need help with excel data and plenty of sheets...

    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...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-10-2014, 01:17 AM
  2. Replies: 0
    Last Post: 07-02-2014, 04:13 PM
  3. copy data from a excel sheet to different excel sheets automaticaaly
    By Jpkrish in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2014, 12:05 PM
  4. [SOLVED] Excel vba copy data from general sheets and organize them in separate sheets.
    By excelsubb in forum Excel Programming / VBA / Macros
    Replies: 40
    Last Post: 01-24-2013, 08:01 AM
  5. data entry in excel by linking to other word doc. or excel sheets
    By wangxuqin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 07:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1