well it went over my head bro am not good with VBA at all... that why if anyone can kindly modify it. cause i want the only selected data from A.xls>sheet1 in B.xls sheet1 the b.xls already have been created...it a existing xls workbook.
=IF(Database!B2="", "", IF(Database!B2=INDEX(INVENTORY!B:B, MATCH(B2,INVENTORY!B:B, 0)), "", "mismatch"))
this formula is showing subjected Error...rather then showing Mismatch is the cell value is not found...
kind improve the formula for me id be really glad....
Can any one Kindly Plssss...Modify this Coding To The Selected Data From 1 WorkBook's Sheet1 To Another Already Created WorkBook's Sheet1 in My documents.
Will Appreciate the HELP
Sub CopySelectedMulti()
Dim NextRow&, rng As Range
With Sheets("Sheet2")
For Each rng In Selection.Areas
On...