noboffinme
Registered User.
- Local time
- Tomorrow, 07:52
- Joined
- Nov 28, 2007
- Messages
- 288
Hi
I have a workbook with 2 worksheets, wksht1 & wksht2.
'wksht1' has column "A" which contains numbers (Long) with duplicates.
'wksht2' has the summarised column of numbers from wksht1, no duplicates.
I want to select a number in wksht1, find the value (String) that is 10 Columns to the right & hold that value.
The code moves up the column, finds the same number & value 10 columns to the right & holds that value.
When the are no more matches to that number in the column in wksht1, the values are pasted into wksht2 on the row where the number matches.
I'm mainly having issues with holding all the values for the same number in the column on wksht1 before I move over to paste the values onto the new sheet.
Can anyone assist?
I have a workbook with 2 worksheets, wksht1 & wksht2.
'wksht1' has column "A" which contains numbers (Long) with duplicates.
'wksht2' has the summarised column of numbers from wksht1, no duplicates.
I want to select a number in wksht1, find the value (String) that is 10 Columns to the right & hold that value.
The code moves up the column, finds the same number & value 10 columns to the right & holds that value.
When the are no more matches to that number in the column in wksht1, the values are pasted into wksht2 on the row where the number matches.
I'm mainly having issues with holding all the values for the same number in the column on wksht1 before I move over to paste the values onto the new sheet.
Can anyone assist?