How to import data from one .xlsx to another .xlsx when the number of columns are exceeding 255 columns? I have tried multiple methods of Data importing but it doesnt work beyond column IV or 255 columns.
My source xlsx file is updated on a daily basis and my code should be dynamic enough to pick all the columns. Rows remain constant.
My current data range = D4:JO24
Expected to keep growing beyond JO every day.
Please help!!
My source xlsx file is updated on a daily basis and my code should be dynamic enough to pick all the columns. Rows remain constant.
My current data range = D4:JO24
Expected to keep growing beyond JO every day.
Please help!!
Last edited: