Sir's

Any one please send VBA Macros Programming Grammar pdf file. please

I am very much interested to learn a Macros & VBA in Excel kindly advice to best BOOKS or institutes in Hyderabad city.

VINOD

Sir,

I am very much interested to learn a Macros & VBA in Excel kindly advice to best institutes in Hyderabad city.

VINOD

Sir,

i am entering data which contains A1 Chq no. and B1 amount i am entering one by one chq no and amount.

Now i need to not allow same chq no. in A1 column i am trying to use data validation (customs, countif formula).

kindly advice.

VINOD

Sir,

i have data contains 1000 Chq no. i.e, A1 to A1000 (double chq no's) and amounts in B1 to B1000

Now i need to pickup same chq no. to same amount ie.,

chq no. amount

12345 1000000
12345 3000000

i am using Vlookup formula but my vlookup is pickuping only first value in B1 how to pickup second value through using vlookup.

kindly advice.

VINOD

Sir / Madam's

I have data which contains cheques numbers and amounts from A1 to A41000 and B1 to B41000 (doubled).

now i have to map the same chq no. and same amounts i.e., EX:

chqno. amount

335664 1,00,000
335664 1,00,000
335664 1,00,000

110001 2,00,000
110001 2,00,000
110001 2,00,000

how do i do this. Kindly advice sir / Madam

VINOD

VENDORS PAYMENT DETAILS

1 2 3 4
SL.NO IN FAVOUR AMOUNT THROUGH

1 ABC LTD 30,000.00 DD
2 XYZ PVT LTD 25,000.00 CHQ
3 ZYX LTD 15,000.00 DD
4 CBA SOLUTIONS 2,000.00 CHQ
5 SOMU 8,000.00
6 RANI 6,000.00
7 RANGA 5,400.00
8 RAMANA 56,000.00

Sir

in above table i need to fill in 4th row only DD or CHQ not other characters of any like RTGS, Netbanking etc., how it is possible (details given in attached xls file)