acc

Hi all I have file data.xlsm with 03 sheets("result","balance01","balance02") Now I want macro VBA to check value each account number in row i sheet(balance01).column(B,C) with the same account number in row j sheets(balance02).column(F,G) If the same account but value(Bi) <> value (Fj) or...

I have data in the below format: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO D1 D2 D3 D4 D5 STATUS F4/337 5973 10.6 10.59 10.59 10.59 10.59 ACC F4/338 5973 10.6 10.58 10.59 10.6 10.6 ACC F4/339 5915 10.61 10.62 10.61 10.61 10.62 ACC F4/340 5986 10.59...

I have a large no. of entries in excel like below: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO Density STATUS F2/146 5820 10.48 10.49 10.48 10.5 10.49 ACC 10.49 10.49 10.49...

Hi all, I try to reserve any questions to this forum that are a little challenging - so apologies for the following as I really should know how to do this. In short, a taxi company has daily contracts and simply add which taxis took the job - at the end of the month the drivers get paid. The...

Hello, Column I have some info + acc number. Id like to strip this column of everything beside acc. how delete everything beside last 32 chars? =Right(I2;32) but to all in column I and with VBA Thank You :)