arundharmarajan
New Member
- Joined
- Jun 12, 2018
- Messages
- 6
After the brilliant solution to my thread https://www.mrexcel.com/forum/excel-questions/1059039-listing-all-values-within-range-values.html (which I am still working out on understanding the code), if there is more than one requirement in the sheet, is this possible??
If Value A, Value B, List for B(the entire possible values in B sorted) is provided, with the click of a button, Desired Output - A&B should be generated.
Also, when Value C and Value D are provided, with another button, Desired Output - C&D should be generated.
The number of rows will obviously will vary and the data will be in two different workbooks/sheets.
With my very amateur knowledge in macro, I could concatenate few values for desired output for A&B, but blank cell and the "0000" becomes 0, thereby messing with the output.
Hoping for a solution and better understanding of macros.
Thank you very much.
If Value A, Value B, List for B(the entire possible values in B sorted) is provided, with the click of a button, Desired Output - A&B should be generated.
Also, when Value C and Value D are provided, with another button, Desired Output - C&D should be generated.
The number of rows will obviously will vary and the data will be in two different workbooks/sheets.
With my very amateur knowledge in macro, I could concatenate few values for desired output for A&B, but blank cell and the "0000" becomes 0, thereby messing with the output.
Hoping for a solution and better understanding of macros.
Thank you very much.
