Forum Discussion
how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual b
how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual basic excel? Tables have variable length and have more than 10000 rows. school.xlsx |A | B | C| ...
how about idea to use another shool2.xlsx file that renew only old values with old values where value return by formula is Not found
If to keep previous value in stack and return into the same cell result of calculation or previous value, depends on condition, that's only with VBA. Can't help with it.
If Power Query it'll be one more table which merge these two ranges and return the value from one or another depends on they match or not. Mockup is in attached file.
How dose file school.xlsm was made with power query?
how does Mockup make?