Conditionally Copy the data.Closed

Question

Hello All,

I'm using MS Office 2003 on Windows Vista and trying to create a personal budget workbook. I have a work sheet named 'Expenses' which have following columns;
1. 'Date' - To Enter date.
2. 'Description' - To enter description about expenses.
3. 'Category' - To enter category of expense.
4 'Account' - Account from where we invested.
5 'Amount' - Amount Invested.
6 'Total'. - Total amount invested in the month.

I need to create few more sheets say 'Home-Provisions', where I need to copy all rows from 'Expenses' where 'Category' is 'Home-Provisions'.

Is there any way of doing it without Macros. If not, how it can be done using Macros. Although I'm a software engineer but I do not have any experience VBScript or macros programming.

Thanks in Advance for any help.

Kapil Sharma.

mubashir aziz · Answer

You can use Auto Filter if you only want to know about categories and then you can manually copy the selected rows to another sheet. 

Or the best thing is to use PIVOT Table / Chart.  Bcoz you have computer background and you can easily pick up these things especially Pivot Table which work just like MS Access Query ......

KapilSharma · Answer

Thanks for your reply.

Manually coping data is not practical as there are one sheet per category and around 25 categories.

Can you tell me a bit more on Pivot table. I try setting them but I'm not getting expected result. I need whole row to be copied where category is any particular. In other words, I want to separate records based on categories.

Thanks,
Kapil Sharma

mubashir aziz · Answer

Try this link to understand Pivot ...... 

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Conditionally Copy the data.

3 responses

Similar discussions

Subscribe To Our Newsletter!