Copying the repeated data of the previous sheet to the next sheet
 

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

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