excel experts required

  1. Z

    Retrieving data from one Excel sheet to another (More like amkig Access like queries in excel)

    Hi, I have a database of 338 members, all the information is entered in an excel sheet (named: Main) column wise, lets suppose the data for the first member is in the row 2 (first row is used for column headers) i.e.: A1 contains Serial (Here 1) B1 contains First Name (Here John) C1 contains...
  2. S

    consolidating worksheets

    Hi to all excel experts out there... I am trying to find a way to consolidate data from several workbooks into one however the data must come from the separate workbooks and has to be updated everytime the consolidated workbook is opened. There is a nice twist to this one aswell... the data...

Some videos you may like

This Week's Hot Topics