Here is my query. I will hopefully make some since here. WhatI am trying to do is write code that looks at another spread sheet and copies the values from a column range to another spreadsheet in a seperate workbook. I have code for most of this.
The problem
I need to copy a different column range for a given spreadsheet. I want to index that to a cell in the spreadsheet that the values are being copied into.
IE: Estimate 1 The one being in its own cell telling the code to look in a given column on the other sheet. Is there a way to index a cell range by column? I know it can be done by row.
Any help would be much appreciated. I have went through the search and have some ideas from there but nothing definitive.
Thanks in advance
Paul
The problem
I need to copy a different column range for a given spreadsheet. I want to index that to a cell in the spreadsheet that the values are being copied into.
IE: Estimate 1 The one being in its own cell telling the code to look in a given column on the other sheet. Is there a way to index a cell range by column? I know it can be done by row.
Any help would be much appreciated. I have went through the search and have some ideas from there but nothing definitive.
Thanks in advance
Paul