7
70316
Ok, let's hope I explain this properly, and if I am posting in the wron
site, I apologize.
I have three excel 2003 worksheets, all saved in the same file. Eac
sheet has a linking number, in column A. What I want to do is, take th
first entry in the first worksheet, and check the other two worksheet
for that linking number.
If there is a corresponding linking number, I want it to take th
information in that row and copy and paste it to the correspondin
entry in the first worksheet.
For example,
I have three columns of information in worksheet #1. The first colum
is the linking number. If the first number is 10, I want it to searc
worksheets #2 and 3 for that linking number. if either sheet has it,
want it to copy the information in that row and paste it to the end o
the row in worksheet #1. if the linking number doesn't exist in th
other two worksheets, then the command should just be ignored
site, I apologize.
I have three excel 2003 worksheets, all saved in the same file. Eac
sheet has a linking number, in column A. What I want to do is, take th
first entry in the first worksheet, and check the other two worksheet
for that linking number.
If there is a corresponding linking number, I want it to take th
information in that row and copy and paste it to the correspondin
entry in the first worksheet.
For example,
I have three columns of information in worksheet #1. The first colum
is the linking number. If the first number is 10, I want it to searc
worksheets #2 and 3 for that linking number. if either sheet has it,
want it to copy the information in that row and paste it to the end o
the row in worksheet #1. if the linking number doesn't exist in th
other two worksheets, then the command should just be ignored