Forum Discussion
asking for help to solve my problem
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 Sheet2
as 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 member
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 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
TARUNKANTI1964More 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?
- 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
