We help IT Professionals succeed at work.

# populate  some cells after data verification

ADRIANA P asked
on
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
Comment
Watch Question

## View Solution Only

Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
What is the logic behind these numbers? "01,29,79,09,99,19,69,44,49,41,46,66"
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
With what you are comparing B7 to be true?
ACCOUNTING ASSISTANT

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"
ACCOUNTING ASSISTANT

Commented:
IF TRUE I NEED PUT 01 IN C7, 29 IN D7, 79 IN E7 ECT...
ACCOUNTING ASSISTANT

Commented:
IF THAT POSIBLE ?
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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),",",""))
``````
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
ACCOUNTING ASSISTANT

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..
ACCOUNTING ASSISTANT

Commented:
MY CORRECTION IF 01 APPEAR IN B20
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Wherever you have 01 in B Column, you need to have those numbers in O column as well.

Please find attached.
Book2_v2.xlsx
ACCOUNTING ASSISTANT

Commented:
YES !
ACCOUNTING ASSISTANT

Commented:
BUT THE EXAMPLE YOU SEND ME IS NOT WHAT I NEED BECAUSE
DUPLICATE THE DATA
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Then please send me with every examples what you need?
ACCOUNTING ASSISTANT

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
ACCOUNTING ASSISTANT

Commented:
EACH NUMBERS IN AN CELL  EXAMPLE
01 IS IN B20 , 01 IN C20, 29 IN D20, 79 IN E29 ECT..
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
This is the same result you are getting splitting the numbers in each adjacent cell, where 01 appears in B Column.
ACCOUNTING ASSISTANT

Commented:
NO IS NOT
ACCOUNTING ASSISTANT

Commented:
IS ANY WAY
WHEN 01 APPEAR TO POPULATE THE CELLS
BUT NOT DUPLICATE THE SAME  DATA ???
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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:
ACCOUNTING ASSISTANT

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
ACCOUNTING ASSISTANT

Commented:
IF TRUE  what i want is ti populate the cells with this data but each number in separete cell
ACCOUNTING ASSISTANT

Commented:
sorry for my caps ons
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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:
ACCOUNTING ASSISTANT

Commented:
thats is what i dont want to do paste
i need be automatic
ACCOUNTING ASSISTANT

Commented:
every time 01 appear automatic popukate the cells
ACCOUNTING ASSISTANT

Commented:
populate
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
OK please find attached...
Book2_v3.xlsx
ACCOUNTING ASSISTANT

Commented:
is not good
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Apology, I cannot help further.
ACCOUNTING ASSISTANT

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
ACCOUNTING ASSISTANT

Commented:
don't know if have to be doing with visaul basic
but i don't know how to do
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Please find attached last try with formula:
Book2_v4.xlsx
ACCOUNTING ASSISTANT

Commented:
not working sorry

is any way that i can write an statement
with visual basic ??
for that situation??
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
I am busy with. Just hold on
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Please find attached....Click on update columns
Book2_v5.xlsm
ACCOUNTING ASSISTANT

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
ACCOUNTING ASSISTANT

Commented:
i can't do like you say because other data will be there
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Good luck
ACCOUNTING ASSISTANT

Commented:
is interesting but how i can edit if  i need??
ACCOUNTING ASSISTANT

Commented:
you answer don't work for my
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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.
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
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
ACCOUNTING ASSISTANT

Commented:
GREAT JOB ! SHUMS  !!
JUST ONE QUESTION !
CAN I SEE THE CODE BEHIND ??
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Navigate to Developer/VisualBasic and you can see the code
ACCOUNTING ASSISTANT

Commented:
GREAT JOB !
Managing Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're welcome Adriana! Glad it eventually worked for you. :)