Copy filtered data to new Excel workbook and prompt with Save As dialog

Question

I have a worksheet which contains some financial data to be transferred to accounting system.

Can say I know some things about programming, but Excel macros are little too much for me, so please suggest some (even partial) solutions to my problem. Thanks!

Master workbook columns are:

• Name
• Account
• Date
• Followup
• Amount
• Checked
• Transferred

Rows that I need to transfer have Checked="Yes" and Transferred=""

Output worksheet must have two rows for each row of master sheet(since credit and debet must be separated). Output columns must be:

• Date
• Account
• "8888"
• Followup
• Debet(=Amount)
• Credit(=empty)

After that Transferred column of master sheet needs to be set to "Pending", and SaveAs dialog is prompted for new workbook(possibly with some default name and path).

Thanks again!

Answer 1

seems to be an easy job which you would enjoy. To start just visit - http://www.ozgrid.com/Excel/free-training/basic-index.htm

If you need any specific help feel free to write..

Cheers..