how do I populate a cell with data from another worksheet,

D

deniseh

I have two worksheets, both with similar data. Say columns are Acc No, Acc
Name and VAT number. Unfortunately the VAT number does not correspond on
each worksheet. How can I populate 1 worksheet with the VAT number so that
the data is collected on one worksheet? I have tried VLookup, but I'm not
really converant with it so would appreciate any help.
Many thanks
Denise
 

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.

Ask a Question

Similar Threads

how do I populate a cell with data from another worksheet, 3
Move rows with vlookup 3
Populate cell with data from another worksheet 4
Can the IF function be used with values from multiple worksheets? 4
How do I clear a form? 0
Auto populate monthly and quarterly data 5
My Excel file is not calculating! 13
Auto deletion of cell entry in given circumstance 0

Top