Thread View: microsoft.public.excel.misc
3 messages
3 total messages
Started by Maryanne
Tue, 03 Nov 1998 00:00
Macro copy info. to new sheet
Author: Maryanne
Date: Tue, 03 Nov 1998 00:00
Date: Tue, 03 Nov 1998 00:00
34 lines
1952 bytes
1952 bytes
I have a question is there an easy way to extract certain data out of one sheet and move it to another sheet? At work I am having to manipulate the numbers in Accounts 100 through 500. These numbers are mixed in with other accounts. What I was attempting to do is create a macro that will go through and copy all the information pertaining to accounts 100 through500 to a new sheet which I had planned to name "Data". I had tried several things with regards to copying account numbers greater than or equal to 100 and less than or equal to 500. But I keep getting error messages. Unfortunately the accounts are not in numerical order so I have to hunt through the worksheet called "Amounts" and copy that data over to a new sheet I planned to name "Data". Another problem is that when I tried to get a macro to copy from the"Amounts" worksheet to the "Data" worksheet, on several occasions the prior information in the "Data" worksheet was covered up with the new information I had just copied over. I am about to go mad with this - please help. In column A I have my account number (for example: 100), in column B I have a product code (like: 323432), then in column C in the product name (misc. exp.), in column D are the prices and then in column E the total for that account number, which is on the same row as the last product information. The size of each set of accounts varies, of course, that was another problem I ran into. Sometimes there might be 4 rows of information in account number 100, then 2 rows of 1000, then maybe 25 rows of account number 450. I am so frustrated this should not be this hard. Each product has an account number and the total is in the last column on the same row as the last product but I just canοΏ½t do it. All I wanted to do was to get all accounts with numbers between 100 and 500 on a separate sheet. I never thought it would drive me crazy. Thank you for your assistance, Maryanne
Re: Macro copy info. to new sheet
Author: BillMeister@abac
Date: Thu, 05 Nov 1998 00:00
Date: Thu, 05 Nov 1998 00:00
29 lines
1018 bytes
1018 bytes
Hi MaryAnne: It can be done very simply manually by using DATA FILTER AUTOFILTER Click anywhere in the body of the data ans invoke the autofilter per above. Then you'll see the little down arrows at the top of all the columns. Click the arrow under column A and select CUSTOM. You can use two select criteria. The first should be "greater than or equal to" enter 100 in the box Then click the "and" logical connector. The second should be "less than or equal to" enter 500 in the box. Click OK and all you will see are rows satisfying the conditions. Highlight these and copy them to your new sheet. If you turn on your macro recorder when you do the above you will genrate a macro that should do what you want. This is one method. There are others. Good luck BillMeister@abac.com On 3 Nov 1998 23:10:48 -0800, Maryanne Brown wrote: >I have a question is there an easy way to extract certain data out of one sheet >and move it to another sheet? > > >Thank you for your assistance, >Maryanne BillMeister@abac.com
Re: Macro copy info. to new sheet
Author: BillMeister@abac
Date: Thu, 05 Nov 1998 00:00
Date: Thu, 05 Nov 1998 00:00
29 lines
1018 bytes
1018 bytes
Hi MaryAnne: It can be done very simply manually by using DATA FILTER AUTOFILTER Click anywhere in the body of the data ans invoke the autofilter per above. Then you'll see the little down arrows at the top of all the columns. Click the arrow under column A and select CUSTOM. You can use two select criteria. The first should be "greater than or equal to" enter 100 in the box Then click the "and" logical connector. The second should be "less than or equal to" enter 500 in the box. Click OK and all you will see are rows satisfying the conditions. Highlight these and copy them to your new sheet. If you turn on your macro recorder when you do the above you will genrate a macro that should do what you want. This is one method. There are others. Good luck BillMeister@abac.com On 3 Nov 1998 23:10:48 -0800, Maryanne Brown wrote: >I have a question is there an easy way to extract certain data out of one sheet >and move it to another sheet? > > >Thank you for your assistance, >Maryanne BillMeister@abac.com
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads