Import data from one sheet to another

Question:

( by Frank Bernard )

I am building a expense report. I also just downloaded an app that I can keep track of my expenses.  This app exports csv files and I would love to be able to copy and paste this data in to on of the sheets in my google document. With that I would love for the spreadsheet to sort everything out. I have different expenses that I have on another sheet that I separate in to different tables according to the expense.  I was wondering if there is a way to filter that data to the according table.  To be more specific with my answer I have two sheets. CSV file come with the headers Category, Source, Expense, Date, and Amount.  The other sheet I want to filter the data has only the headers Source, Expense, Date, and Amount. No Category. The table already contains that and there is no need for it. I have spent countless hours trying to figure this out with no luck. If somebody could let me know if this can be done and how I would be very grateful. If it can't then I know to stop wasting my time.  Thank you in advance.


Solution:

Here is the screenshot of Sheet1:

Now in Sheet2 type the following formula in Cell A1:
=ArrayFormula('Sheet1'!B:E)

It will populate your Sheet2 with Columns B to Column E.


Here is the screenshot of Sheet2:

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private or confidential projects:

http://igoogledrive.blogspot.in/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan,

iGoogleDrive