Link to home
Create AccountLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

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
Avatar of Shums Faruk
Shums Faruk
Flag of India image

What is the logic behind these numbers? "01,29,79,09,99,19,69,44,49,41,46,66"
With what you are comparing B7 to be true?
Avatar of ADRIANA P

ASKER

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"
IF TRUE I NEED PUT 01 IN C7, 29 IN D7, 79 IN E7 ECT...
IF THAT POSIBLE ?
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
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..
MY CORRECTION IF 01 APPEAR IN B20
Wherever you have 01 in B Column, you need to have those numbers in O column as well.

Please find attached.
Book2_v2.xlsx
YES !
BUT THE EXAMPLE YOU SEND ME IS NOT WHAT I NEED BECAUSE
DUPLICATE THE DATA
Then please send me with every examples what you need?
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
EACH NUMBERS IN AN CELL  EXAMPLE
01 IS IN B20 , 01 IN C20, 29 IN D20, 79 IN E29 ECT..
This is the same result you are getting splitting the numbers in each adjacent cell, where 01 appears in B Column.
User generated image
NO IS NOT
IS ANY WAY
WHEN 01 APPEAR TO POPULATE THE CELLS
BUT NOT DUPLICATE THE SAME  DATA ???
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:
User generated image
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
IF TRUE  what i want is ti populate the cells with this data but each number in separete cell
sorry for my caps ons
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:
User generated image
thats is what i dont want to do paste
i need be automatic
every time 01 appear automatic popukate the cells
populate
OK please find attached...
Book2_v3.xlsx
is not good
Apology, I cannot help further.
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
don't know if have to be doing with visaul basic
but i don't know how to do
Please find attached last try with formula:
Book2_v4.xlsx
not working sorry

is any way that i can write an statement
with visual basic ??
for that situation??
I am busy with. Just hold on
Please find attached....Click on update columns
Book2_v5.xlsm
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
i can't do like you say because other data will be there
Good luck
is interesting but how i can edit if  i need??
you answer don't work for my
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.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
GREAT JOB ! SHUMS  !!
JUST ONE QUESTION !
CAN I SEE THE CODE BEHIND ??
Navigate to Developer/VisualBasic and you can see the code
GREAT JOB !
You're welcome Adriana! Glad it eventually worked for you. :)