Hello All,
I wish you all a happy new year.
I m still working in this issue. I changed my file.
I now have just 2 Columns (A , B) with the codes from line 2 to 1 000.
I need different thinks for this.
1) I first need to delete all the values from each colums that are twiced in the same colomns. Which means to delete all doubloons from the columns.
2) Then I need to...
moutoncito
Last Activity: Jan 11 '10, 01:47 PM
Joined: Nov 25 '09
Location:
-
Hello all,
Thanks for the help, i might explain better my case.
Each day i have to compare to worksheets with lists in cells A,,B,C,D . One of the workbooks is an update of the previous day list, and the second one is the previous day list.
Normally i do an IF function and then i apply and autofilter and then i have to arranged mi sheets, to see the differences between the 2 sheets (the new and old one). Normally...Leave a comment:
-
Thanks 4 the help. The macro works , but ir display the values that match in both sheets and i need the unmatch values. Can you help me???Leave a comment:
-
Hello ADezii :
I tried to use the macro that you send me, and i have no results displays !!!
I don t know how to do?? And i didn t understood the last part of your code??
OUTPUT
Value 66 in Sheet1 found at $D$31 in Sheet2
Value 77 in Sheet1 found at $C$16 in Sheet2
Value 9998887 in Sheet1 found at $F$100 in Sheet2
Value 3456 in Sheet1 found at $C$7 in Sheet2
Value 66 in Sheet1 found at...Leave a comment:
-
Excel: VBA code that look for values and compare it
Hi all,
I need some help with a VBA code. I have tried differents codes that i fund in the forum but they didn t match with what i m looking for. So i will explain what i have , what i need and what i expect.
I have a workbook with 2 sheets (Sheet1 , Sheet2). Both sheets have values in columns A to F. (A:F). Values Start at A2. B2..... etc in both sheets, and end up sometimes at A1000. B1000. ... etc.
...
No activity results to display
Leave a comment: