zbor
Forum Guru

Hi zbor, i noticed i have duplicated my post and that you have closed it, i was asked by Lieth Ross to upload the attachment but was unsure on how to do it without starting a new post, i apologise for that but will he still be able to view it regards chris

Hi zbor ... could u please help if u r free rite now ?
many many thanx in advance !

hi,
i have a problem in writing macro for comparing two sheets in a workbook in such a way
if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
this process must continue till all the row compared one by one of first sheet with second sheet
means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
please help me to slove this problem

Am not used to this forum and am at a lost.how do i look for my my original message?
thx

I can not attach a spreadsheet because I do not have 2007 on this computer :-( If you need more information to help me (first time user) then please let me know.

Thanks, Josette

I am not sure this is the right way to go about it but could you explain what 99^99,--RIGHT does? Your formula works great =LOOKUP(99^99; --100*RIGHT(D30; ROW(1:10))) but I don't understand that part? If you have time

Ken
g48dd

Answer to the thread 777977 (unique values) is indeed an Zbor special. I never tried (succeeded) it with formula. This will certainly help me to better many of my excel formats. Thanks again.

Happy Easter Zbor! (one day in advance! )

Hi - did you manage to take a look at my uploaded example spreadsheet?

not sure if it uploaded ok? - my query was posted today (Newport Count) regarding a formula performing a count and then calculating the instances over 90 days, under 30 days etc

thanks mate

I've not forgotten your OL thread I just need to find some time to look at it properly... the basic code is on: http://www.excelforum.com/excel-prog...rom-excel.html