I am trying to import partial data from an outside excel file. I have the code so far to open the outside Excel file but I can’t figure out how to copy only certain columns and rows of data.
Once the outside file has been opened, I need to copy as follows (without deleting any columns as I need the values to compute other data once I have this part working):
copy column A (sourceWkb) to column A (destinationWkb)
copy column C (sourceWkb) to column C (destinationWkb)
copy column F (sourceWkb) to column D (destinationWkb)
copy column H (sourceWkb) to column F (destinationWkb)
copy column J (sourceWkb) to column G (destinationWkb)
There is also one other criteria, which is the only copy rows in which the value in column G for the sourceWkb = “Chicago”
I have attached a copy of data file and copy of file with desired results.
Bookmarks