Outline ·
[ Standard ] ·
Linear+
Excel sort by date
TSdjzone111
|
Mar 25 2016, 07:06 PM, updated 8y ago
|
Getting Started
|
I have a problem here. In excel, how can I retrieve data from multiple tabs (15 tabs) into on sheet ?
Is there a function that I can use eg: if, sumif, vlookup etc ? I need to search the date (day by day) in 15 tabs and place the data into one sheet.
Please help, thanks. This post has been edited by djzone111: Mar 25 2016, 07:26 PM
|
|
|
|
perfectgrowwell
|
Mar 25 2016, 09:22 PM
|
Getting Started
|
Hi! I try answer your question.
For example, sheet1, sheet2 and sheet3 display on your excel.
Let say, sheet1 I key in data in A2 and sheet2 key in data in A3, then I need sheet3 to get data from A1 and A2 in sheet3, formula=Sheet1!A2 in particular column and row.
Maybe I'm wrong is not the one you want.
|
|
|
|
TSdjzone111
|
Mar 26 2016, 12:58 PM
|
Getting Started
|
QUOTE(perfectgrowwell @ Mar 25 2016, 10:22 PM) Hi! I try answer your question. For example, sheet1, sheet2 and sheet3 display on your excel. Let say, sheet1 I key in data in A2 and sheet2 key in data in A3, then I need sheet3 to get data from A1 and A2 in sheet3, formula=Sheet1!A2 in particular column and row. Maybe I'm wrong is not the one you want. Hi, I need to search tabs (sheet1, sheet2, sheet3 etc) for the day by day date. Thanks. This post has been edited by djzone111: Mar 26 2016, 12:59 PM
|
|
|
|
SUSAmeiN
|
Mar 26 2016, 01:23 PM
|
|
|
|
|
|
TSdjzone111
|
Mar 29 2016, 06:37 PM
|
Getting Started
|
QUOTE(AmeiN @ Mar 26 2016, 02:23 PM) Thanks...
|
|
|
|
fever003
|
Apr 1 2016, 04:04 PM
|
Getting Started
|
QUOTE(djzone111 @ Mar 25 2016, 07:06 PM) I have a problem here. In excel, how can I retrieve data from multiple tabs (15 tabs) into on sheet ?
Is there a function that I can use eg: if, sumif, vlookup etc ? I need to search the date (day by day) in 15 tabs and place the data into one sheet.
Please help, thanks. Hi, Can you elaborate more on what you require? Most importantly, I would liek to have a look at the layout so I can suggest a solution.
|
|
|
|
wkphang
|
Apr 17 2016, 06:20 PM
|
Getting Started
|
Can use macros.....else u can use mixture of vlookup and formulas (but it will get messy)
|
|
|
|
TSdjzone111
|
Apr 23 2016, 05:53 PM
|
Getting Started
|
QUOTE(wkphang @ Apr 17 2016, 07:20 PM) Can use macros.....else u can use mixture of vlookup and formulas (but it will get messy) Thanks for ur help. I found a link that maybe useful : http://superuser.com/questions/219201/exce...multiple-sheets=sum(Jan:END!A1) This formula will add up all the values in A1 from each sheet between Jan and End. This post has been edited by djzone111: Apr 23 2016, 06:02 PM
|
|
|
|