1st column is for invoice no , 2nd column for customer name, and 3rd column
for address, this data is in both sheet.
whenever customer pay the invice amount, i just type the invoce no and the
customer name appear,i used the vlookup formula for one sheet, but its not
work if data is in 2 sheet. some inovice no is in 2 sheet.
With the capacity of 65,000 rows for each sheet, why can't you combine your
4 sheets into 2?
It'll make your life *much* easier and simpler.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
dear,
my date base is in 4 sheets,your formula work only for 2 sheets.
i want the formula for 4 sheets.
pls help
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.