Good day!
I am looking to retrieve data from a SQL sever then place that data in multiple columns (if required).
I have an array of cells in the workbook. There are three columns. Each column is 8 rows deep. Each column is made up of 4 merged cells (for formatting consistency).
Column 1. W57:W64 Each "Cell" is 4 cells so position 1 is actually a merge of W57-Z57.
Column 2. AB57:AB64
Column 3 AG57:AJ64
SQL statement can return from 2 to 24 values.
I want the to be able to write the record set to fill column 1 - starting at W57, then continue in column 2 - starting at AB57, etc.
Your skilled help would be appreciated.
I am looking to retrieve data from a SQL sever then place that data in multiple columns (if required).
I have an array of cells in the workbook. There are three columns. Each column is 8 rows deep. Each column is made up of 4 merged cells (for formatting consistency).
Column 1. W57:W64 Each "Cell" is 4 cells so position 1 is actually a merge of W57-Z57.
Column 2. AB57:AB64
Column 3 AG57:AJ64
SQL statement can return from 2 to 24 values.
I want the to be able to write the record set to fill column 1 - starting at W57, then continue in column 2 - starting at AB57, etc.
Your skilled help would be appreciated.
