So this is this is the file range data uh data you want to write to and then this is the data type in the exact same fashion okay so let me quickly demonstrate this.
Again setting the source range which is a5 to f7 uh so a5 to f7 like this okay uh now let me go to.
A5 to f7 here let me highlight so that we know the value actually got updated so i'm gonna just put an x.
Like this and once we run this update method basically it's gonna take this data and update that particular range in google sheet.
Okay so uh again this is a source restating the data to b data variable reconstructing it in the format it's acceptable to open data array.
Term you're saying okay copy this data and paste it here like this it's uh similar in that way okay so coming back here.
And i'm gonna execute this yeah so it appended i mean updated this particular range okay so let's say that you imported the sheet with the thousands of.
You know cells with data you can run uh the update and all this manipulation within vba excel and then you can write back you know using this update method as well.