I have an excel work book contains with two sheet as Sheet1 and Sheet2. in Sheet1 there is three columns named Column A - Chasis Number , Column B - License ID and Column C - Chasis Number. in column A is filled by some data which is also repeated in Column C. In Column B Column B - License ID is related with Column C. in Sheet2 there is also three Column named Column A - Chasis Number , Column B - License ID and Column C - Chasis Number , but all column is empty. now i want to transfer the all repeated data of Column A and Column C with related data in Column B of Sheet1 to Sheet2as per column wise as it is with any Excel Formula or VBA Code. Hope i can get Cooperation from tech community team in this regards Many thanks to all of tech community team memberTARUNKANTI1964

TARUNKANTI1964 Do you mean repeated Chasis Number could be the same in any row of column A and/or in any row of column C, not the same numbers in the same row? If the former, for which rows to take License ID?

Respected, actually I like to say repeat means if a Chesis Number found in Column C it may be found in Column A so in this situation I need which Chesis Number found in both Column A and C that would be transferred from Sheet1 to Sheet2 with Licence Number as per row would be found in Sheet1 in Column B

Respected Sergei Baklan,due to my language problem i feel like i cannot clear my matter to You i apologies to You for this. actually in Sheet1 in Column A all Chesis Number must be Found in Column C but i do not know which Chasis Number in Column A are repeating in Column C in which Row. Now let's talk about License ID, actually License ID is related with Chasis Number found in Column C and it will must be transferred to Sheet2 in Column B. in Sheet2 there is also found Column A for Chasis Number, Column B for License ID and Column C for Chasis Number. now i want an Excel system by which i may get data in Sheet2 from Sheet1 as per Serially Row and Column wise. After that if You have any difficulty in understanding then You can let me know againMany thanks to all of tech community team memberWith Humble RegardsTARUNKANTI1964

TARUNKANTI1964 More clear, thank you. However, still not sure how it shall work. Perhaps you may share desired results on small sample, let say source data (Sheet1) is like What shall be for above data in output (Sheet2)? Another question is on which Excel your are, is that 365? If not, which version/platform?

SergeiBaklan Respected @Sergei Baklan Sir, Actually what that is what I want, You may find it which I shared in attached file as sample for Your understanding. Data shall be transferred as my per desire from Sheet 1 to Sheet 2 as per my attached Excel Book named “Sample in Short Form” According to Row wise. ROW number may be extended up to 30000 No's in every Sheet. Platform - EXCEL 2016Hope for Kind solicitationWith Humble Regards@TARUNKANTI1964

asking for help to solve my problem | Microsoft Community Hub

SergeiBaklan
MVP
Apr 12, 2024
TARUNKANTI1964

Do you mean repeated Chasis Number could be the same in any row of column A and/or in any row of column C, not the same numbers in the same row? If the former, for which rows to take License ID?
- TARUNKANTI1964
  Brass Contributor
  Apr 12, 2024
  Respected, actually I like to say repeat means if a Chesis Number found in Column C it may be found in Column A so in this situation I need which Chesis Number found in both Column A and C that would be transferred from Sheet1 to Sheet2 with Licence Number as per row would be found in Sheet1 in Column B
- TARUNKANTI1964
  Brass Contributor
  Apr 13, 2024
  Respected Sergei Baklan,due to my language problem i feel like i cannot clear my matter to You i apologies to You for this. actually in Sheet1 in Column A all Chesis Number must be Found in Column C but i do not know which Chasis Number in Column A are repeating in Column C in which Row. Now let's talk about License ID, actually License ID is related with Chasis Number found in Column C and it will must be transferred to Sheet2 in Column B. in Sheet2 there is also found Column A for Chasis Number, Column B for License ID and Column C for Chasis Number. now i want an Excel system by which i may get data in Sheet2 from Sheet1 as per Serially Row and Column wise. After that if You have any difficulty in understanding then You can let me know again
  Many thanks to all of tech community team member
  
  With Humble Regards
  
  TARUNKANTI1964
  - SergeiBaklan
    MVP
    Apr 13, 2024
    TARUNKANTI1964
    
    More clear, thank you. However, still not sure how it shall work. Perhaps you may share desired results on small sample, let say source data (Sheet1) is like
    
    What shall be for above data in output (Sheet2)?
    
    Another question is on which Excel your are, is that 365? If not, which version/platform?

Forum Discussion

asking for help to solve my problem