populate some cells after data verification

I have data in cel B7  IF IS TRUE I NEED POPULATE THE ADJACENTS  CELL  WITH A LIST OF VALUE

LIKE THE EXAMPLE HERE

HOW CAN I DO THAT ?

THNKS IN ADVANCED
Book2.xlsx
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsDistinguished Expert - 2017Commented:
What is the logic behind these numbers? "01,29,79,09,99,19,69,44,49,41,46,66"
0
ShumsDistinguished Expert - 2017Commented:
With what you are comparing B7 to be true?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
LIKE I SAY GOOD FRIEND
 IF B7 = 01  I NEED THEM POPULATE THE C7, D7, E7, F7, ECT..
WITH THE NUMBERS
"01,29,79,09,99,19,69,44,49,41,46,66"
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
IF TRUE I NEED PUT 01 IN C7, 29 IN D7, 79 IN E7 ECT...
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
IF THAT POSIBLE ?
0
ShumsDistinguished Expert - 2017Commented:
Copy paste your string "01,29,79,09,99,19,69,44,49,41,46,66" in O7, then in C7 paste below formula:
=IF($B7="01",SUBSTITUTE(MID(SUBSTITUTE("," & $O7&REPT(" ",6),",",REPT(",",255)),1*255,255),",",""))

Open in new window

Change the number 1*255 to 2*255 for D7, 3*255 for E7 and so on.

Please find attached for your reference.

Hope this helps
Book2_v1.xlsx
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
NOT REALLY!
WHAT I NEED IS
WHEN 01 APPEAR IN THE LIST OF NUMBERS
POPULATE AUTOMATIC THE ADJACENTES  CELLS WITH THE VALUES
"01,29,79,09,99,19,69,44,49,41,46,66" BUT EACH VALUE SHOUD GO IN AN CELL
01 IN C7 , 29 IN D7 ECTT

BUT IF 01 APPEAR IN OTHER POTISION SAY C20
THAT SHOULD BE THE SAME  01 IN D20, 29 IN E20 ECT..
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MY CORRECTION IF 01 APPEAR IN B20
0
ShumsDistinguished Expert - 2017Commented:
Wherever you have 01 in B Column, you need to have those numbers in O column as well.

Please find attached.
Book2_v2.xlsx
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
YES !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
BUT THE EXAMPLE YOU SEND ME IS NOT WHAT I NEED BECAUSE
DUPLICATE THE DATA
0
ShumsDistinguished Expert - 2017Commented:
Then please send me with every examples what you need?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
WELL I SEND ALREADY
IF A HAVE AN LIST OF NUMBERS AND 01 APPEAR I NEED THE  NUMEBRS
"01,29,79,09,99,19,69,44,49,41,46,66" BE POSTED IN THE NEXT CELLS BUT
EACH NUMBER AN BY CELL  IN THE ADJACENTS CELLS TO WHERE 01 APPEAR
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
EACH NUMBERS IN AN CELL  EXAMPLE
01 IS IN B20 , 01 IN C20, 29 IN D20, 79 IN E29 ECT..
0
ShumsDistinguished Expert - 2017Commented:
This is the same result you are getting splitting the numbers in each adjacent cell, where 01 appears in B Column.
Split Cells
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
NO IS NOT
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
IS ANY WAY
WHEN 01 APPEAR TO POPULATE THE CELLS
BUT NOT DUPLICATE THE SAME  DATA ???
0
ShumsDistinguished Expert - 2017Commented:
Check again,

If B20 has 01, then all adjacent columns has split strings in same rows. See below columns & row number. Which does what you asked for:
Split Cells
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I MEAN
THAT WHY I WRITE THE IF STATEMENTE BUT
I DON'T KNOW HOW MAKE POPULATE  THE CELLS

=IF(b7=1, "01,29,79,09,99,19,69,44,49,41,46,66"," ")
WITH THIS DATA
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
IF TRUE  what i want is ti populate the cells with this data but each number in separete cell
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sorry for my caps ons
0
ShumsDistinguished Expert - 2017Commented:
It wont duplicate the data, if you have another set of numbers for 01, then paste those numbers in Column O. It wont be duplicate.
Check below image:
Split Cells
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
thats is what i dont want to do paste
i need be automatic
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
every time 01 appear automatic popukate the cells
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
populate
0
ShumsDistinguished Expert - 2017Commented:
OK please find attached...
Book2_v3.xlsx
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
is not good
0
ShumsDistinguished Expert - 2017Commented:
Apology, I cannot help further.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
if simple but i don't know hpw to do

if a have an lists of numbers
and 01 appear i need automatic populate the adajacents cells
with  "01,29,79,09,99,19,69,44,49,41,46,66" have to be in separeta cell each number

i can not have those numebres in the first row
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
don't know if have to be doing with visaul basic
but i don't know how to do
0
ShumsDistinguished Expert - 2017Commented:
Please find attached last try with formula:
Book2_v4.xlsx
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
not working sorry

is any way that i can write an statement
with visual basic ??
for that situation??
0
ShumsDistinguished Expert - 2017Commented:
I am busy with. Just hold on
0
ShumsDistinguished Expert - 2017Commented:
Please find attached....Click on update columns
Book2_v5.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sure take your time

my list number

02
58
53
87
96
01 then i need populate with the "01,29,79,09,99,19,69,44,49,41,46,66" the cell in the same row
but i can have other number
lets say
28  then 28 have some data 20,33,47,89,57,55,


that reason i can do like you say
but for now i need 01
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i can't do like you say because other data will be there
0
ShumsDistinguished Expert - 2017Commented:
Good luck
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
is interesting but how i can edit if  i need??
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
you answer don't work for my
0
ShumsDistinguished Expert - 2017Commented:
It will work. Just give me all the relative numbers for all lookup numbers. You provided just one example of 01, for which macro and formula both works.
I would want you to provide me expected result typed manually in your sheet.
0
ShumsDistinguished Expert - 2017Commented:
As per your initial requirement, 01 then i need populate with the "01,29,79,09,99,19,69,44,49,41,46,66" the cell in the same row
Assuming your reference number 01 is in Column B and populating numbers "01,29,79,09,99,19,69,44,49,41,46,66" are in Column C, In Column D there would be formula referring in Column B, If it finds 01, it will auto-populate Column C to D else it would be blank. Then macro will split these corresponding numbers to adjacent cells in the same row.

Please find attached for your reference.

Hope this helps.
Book2_v7.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
GREAT JOB ! SHUMS  !!
JUST ONE QUESTION !
CAN I SEE THE CODE BEHIND ??
0
ShumsDistinguished Expert - 2017Commented:
Navigate to Developer/VisualBasic and you can see the code
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
GREAT JOB !
0
ShumsDistinguished Expert - 2017Commented:
You're welcome Adriana! Glad it eventually worked for you. :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.