Create a list based on input cells.
Closed
j3kj3k
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
-
Dec 1, 2011 at 06:40 PM
j3kj3k Posts 16 Registration date Tuesday June 1, 2010 Status Member Last seen July 11, 2012 - Dec 6, 2011 at 02:02 PM
j3kj3k Posts 16 Registration date Tuesday June 1, 2010 Status Member Last seen July 11, 2012 - Dec 6, 2011 at 02:02 PM
Related:
- Create a list based on input cells.
- Create skype account with gmail - Guide
- My contacts list names - Guide
- Create a yahoo email account for free - Guide
- How to input @ in laptop - Guide
- Excel macro to create new sheet based on value in cells - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 2, 2011 at 06:32 AM
Dec 2, 2011 at 06:32 AM
You would need a macro for that
Can each row have partial repeation
like R1, apple 1000 is on row 1, can it also appear on some other along with some other data. If that is the case then what to do ?
Can each row have partial repeation
like R1, apple 1000 is on row 1, can it also appear on some other along with some other data. If that is the case then what to do ?
j3kj3k
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
Dec 2, 2011 at 06:13 PM
Dec 2, 2011 at 06:13 PM
Yes it can.
I will be able to screen them out if it is necessary.
Thanks for looking into my issue :)
I will be able to screen them out if it is necessary.
Thanks for looking into my issue :)
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 5, 2011 at 11:23 AM
Dec 5, 2011 at 11:23 AM
How many rows are we talking about here .
One approach can be
loop thru each row
loop thru each column
split the content by comma
write to list
next column
next row
but depends on rows columns and how many items can be in one cell ?
One approach can be
loop thru each row
loop thru each column
split the content by comma
write to list
next column
next row
but depends on rows columns and how many items can be in one cell ?
j3kj3k
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
Dec 6, 2011 at 02:02 PM
Dec 6, 2011 at 02:02 PM
Hi rizvisa1
rows (100-200) and columns (30-50) are varying.
and one item per one cell please.
Hope I made it clear.
Thanks in advance.
If it is too much trouble for multiple rows, I can run your script one row at a time.
rows (100-200) and columns (30-50) are varying.
and one item per one cell please.
Hope I made it clear.
Thanks in advance.
If it is too much trouble for multiple rows, I can run your script one row at a time.
