Copying the repeated data of the previous sheet to the next sheet
Hi,
I think its not clear... Let me try to explain another time.
I have data in sheet 1 and sheet 2 of an excel file. I need a formula to
compare the data present in both the sheets and get copied along with the
subsequent columns to the sheet 2 from the sheet 1 of the excel only after
matching with the same text as sheet 2.
"Sasikiran" wrote:
Hello,
I have a problem while exporting a data in an excel sheet.
The first time I have exported I got the data as mentioned in column A and
the relative data is manually entered as in column B
Sheet 1
A B
kjl 34
klj 54
sda 64
sas 23
fsd 45
Next time when I export, some more details are getting added in the A column
and the same was copied to sheet 2 of the same excel file. Now I need a
formula to compare the data present in the sheet 1 which is similar to the
data mentioned in the column A of the sheet 2 along with the data in the
column B of sheet 1 to get copied automatically without doing that manually.
Hope I am clear.. Please help me..
Thanks in advance
|