Conditionally Copy the data.

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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.

3 replies

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
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 ......

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
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Try this link to understand Pivot ......

http://peltiertech.com/Excel/Pivots/pivotstart.htm