Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Data from one sheet to another sheet on a specific day | Excel Worksheet Functions | |||
Add a Sheet From a Previous Sheet Macro | Excel Worksheet Functions | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
Refer new sheet to previous sheet | Excel Worksheet Functions | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |