Array problem?
I am fairly new to this so I am sorry if this is confusing, overly easily or
whatever but I just can't seem to get it right, what I have is a list of names in column A in worksheet 1 from 1 to 126, on worksheet 2 I have 5500 or so rows of data. I have more 5 worksheets with names A,B,C, D and E, each one is to be populated with the rows from worksheet 2. The determining factor is the data in column I on worksheet 2 and which name it is equal to on worksheet 1. The entire row is then to be copied to appropriate worksheet. Unfortunately I don't have access to this site at work and am sending this from home or I could include what I have done so far, although it could be so bad it needs to be completely reworked. TIA all |
Array problem?
Ron de Bruin has code samples for a variety of situations similar to this.
You should be able to adapt his code to your exact situation: http://www.rondebruin.nl/tips.htm -- Regards, Tom Ogilvy "Don" wrote in message ... I am fairly new to this so I am sorry if this is confusing, overly easily or whatever but I just can't seem to get it right, what I have is a list of names in column A in worksheet 1 from 1 to 126, on worksheet 2 I have 5500 or so rows of data. I have more 5 worksheets with names A,B,C, D and E, each one is to be populated with the rows from worksheet 2. The determining factor is the data in column I on worksheet 2 and which name it is equal to on worksheet 1. The entire row is then to be copied to appropriate worksheet. Unfortunately I don't have access to this site at work and am sending this from home or I could include what I have done so far, although it could be so bad it needs to be completely reworked. TIA all |
Array problem?
I'm interested inlearning about arrays, maybe a quick primer for a
lnovices?? "Don" wrote in message ... I am fairly new to this so I am sorry if this is confusing, overly easily or whatever but I just can't seem to get it right, what I have is a list of names in column A in worksheet 1 from 1 to 126, on worksheet 2 I have 5500 or so rows of data. I have more 5 worksheets with names A,B,C, D and E, each one is to be populated with the rows from worksheet 2. The determining factor is the data in column I on worksheet 2 and which name it is equal to on worksheet 1. The entire row is then to be copied to appropriate worksheet. Unfortunately I don't have access to this site at work and am sending this from home or I could include what I have done so far, although it could be so bad it needs to be completely reworked. TIA all |
All times are GMT +1. The time now is 05:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com