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| ...
Sorry, VBA is not my territory. If I understood correctly if the value is not found in age we keep it in school as it is, otherwise take value from age.
I'd use Power Query to combine data such way if that's suitable.
how do we instead of Not found value in third column in shcool.xlsm file have previuos value that was stored before from early version of file age.xlsx? example attach
for example BRS43 now have value Not found but ealier it has value 2. How can we make that file school.xlsm store previos values and formula do not earese previuos value and only update some rows with values from newer age.xlsx file.