I want to shift columns information from “Data Extract” excel to “Main Database” excel. “Main Database” excel columns’ have already some existing information, which I can’t delete or alter. “Data Extract” yellow marked 8 no columns data need to be shifted to “Main Database” 8 no columns. Problem is “Main Database” 8 columns are not located together, rather they are separated by some other columns, which have some default value.
I can copy each columns of “Extract Data” excel file by “read range” activity & store them in different data table but how can i write them in already filled columns of “Main Database” file.
For your convenience/better understanding, I am attaching column name files and “Extract Data” & “Main Database” excel file.
Thanks for your reply. but destination file has columns, which are not located in one place, they are separated by additional other columns. in that case, can i use “Append range” activity? furthermore, Append range activity sometimes does not work properly.
Many Thanks. I just applied your ways & it works perfectly. You saved a lot of my time!! You are a true robot master! You can sense the actual problem/root cause & know the pulse of solution seeker (which is very good quality, i must admire).
just one point, i want to share: I just add “+1” after MainDB.rows.count expression in order to consider header/column name, otherwise it paste in last “value filled” cells:
Thanks once again!!