Hi can anyone help with the following please...

I have a list of account codes in column A and a list of corresponding
account balances in column B.

These account codes are numbered 00,001 through to 10,000.

This is what i'd like to happen but don't know how to do...

On running a macro the user is prompted to enter the range of account
codes they want to copy to "SHEET 2" (say for example 00,001 to
01,999).

On clicking ok the account codes chosen, and the corresponding account
balances are cut or copied and pasted into SHEET 2.

The box then pops up again and asks the user to select the data to
copy/cut into SHEET 3.

This will continue until the user is satisfied that he/she has copied
all the data they wish to work with and click cancel on the pop up
box.

I imagine this is quite complex (certainly it is for me!) but i would
really appreciate any help/input on this. Many thanks in advance


---
Message posted from http://www.ExcelForum.com/

Just turn on the macro recorder and record youself applying an autofilter to
your data using a custom critieria in column A to specify a range of account
numbers. Once the filter is applied, select all your data and copy to the
second sheet. Then turn off the macro recorder.

This give you the code you need to do the copying. I believe you have had
help with Input boxes in the past, so this should be just an extension of
what you have, replacing the hard recorded account numbers with values
retrieved from the input boxes. Get this working and if you still have
questions, post back with your code indicating where you need help.

--
Regards,
Tom Ogilvy
ian123 wrote in message
...
Hi can anyone help with the following please...

I have a list of account codes in column A and a list of corresponding
account balances in column B.

These account codes are numbered 00,001 through to 10,000.

This is what i'd like to happen but don't know how to do...

On running a macro the user is prompted to enter the range of account
codes they want to copy to "SHEET 2" (say for example 00,001 to
01,999).

On clicking ok the account codes chosen, and the corresponding account
balances are cut or copied and pasted into SHEET 2.

The box then pops up again and asks the user to select the data to
copy/cut into SHEET 3.

This will continue until the user is satisfied that he/she has copied
all the data they wish to work with and click cancel on the pop up
box.

I imagine this is quite complex (certainly it is for me!) but i would
really appreciate any help/input on this. Many thanks in advance


---
Message posted from http://www.ExcelForum.com/

Tom,

Many thanks, after playing around with the custom filter options i hav
it working. Thanks a lo

--
Message posted from http://www.ExcelForum.com