• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reg:Combination Against Data Capturing....,

R

rajuctech@gmail.com

New Member
Hi Team,

Greetings from Raju!

i have one doubt the excel,reg the combination data....,

Ex:below mentioned dropdown in column A B C D like

A==>Priority(All,High,Low,Medium)

B===>Region(ALL,Asia,Europe,North Amrica,South America,Canada)

C===>Cluster(All,Angola,Australia,Bangladesh,Belgium,Black Sea,Brazil,China)

D==>EMP Name(All,Peter,Allan,James,Benchamin,Franklin,Avinash,Govind)


A B C D

All Asia Brazil James


am already defined the combinations method below said method, i need how they data capture


AllALLAllAll

AllALLAllPeter

AllALLAllAllan

AllALLAngolaAll

AllALLAngolaPeter

AllALLAngolaGovind

AllALLAustraliaAll

AllALLAustraliaAvinash

AllALLAustraliaGovind

AllALLBangladeshAll

AllALLBangladeshPeter

AllALLBelgiumAll

AllALLBelgiumPeter

AllALLBelgiumAllan

AllALLBelgiumJames

AllALLBelgiumBenchamin

HighALLAllAll


hi kindly suggest


Many Thanks,

Raju
 
Raju,


welcome to Chandoo.org Forums.


Your requirment is not clear and is making dificult to understand what you exactly need.


Please post your specific query and we may be able to help.


~VijaySharma
 
Hi Raju,


If have understood your requirement correctly then, below is the suggestion-:


Now if you want to see the combination of all 4 columns then you can use the formula(=A2 & B2 & C2 & D2) in the "E2" cell.


Similarly, if you want to write the VBA code then it will be-:

Range("E2").FormulaR1C1="=RC[-4]&RC[-3]&RC[-2]&RC[-1]"


Let me know if this helped you, else will suggest something else.
 
Hi Max,


i know how to write the macro coding it's not an issue!


i need the Automation method against how to capture the data(in COmbination menthod).............


Regards

Raju
 
Raju

have a read here: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
You must log in or register to reply here.
Back
Top