A
Alan Barwell
Hi everyone,
Being relatively new to coding in Excel, I'm looking for some guidance to
solve what is probably a pretty straightforward problem.
I have a workbook with multiple sheets, and wish to extract certain
information from one sheet only and copy it to a text file to be imported
into a database. The data starts on row 7 (1-6 are used for header
information) and down to row 450+ (where there is a blank row before other
totals and stuff) and the number of rows will vary each time the export is
run. For each row, I need to pull out certain information from various
columns - for example numbers from columns F:K, a date from column M, more
numbers from Z:AJ, and the result of a SUM formula in column AS. In total I
have 60 columns to extract, so these are just examples. These need to be
written to a sheet/file in consecutive columns. This file will need to have
a predetermined row of header information at the top.
I'm hoping that a few pointers will get me going and I will be able to
finish it off myself, avoiding any likely issues such as dates and formulas
being converted. I'm using Excel 2004. All suggestions greatly appreciated!
Thanks.
Being relatively new to coding in Excel, I'm looking for some guidance to
solve what is probably a pretty straightforward problem.
I have a workbook with multiple sheets, and wish to extract certain
information from one sheet only and copy it to a text file to be imported
into a database. The data starts on row 7 (1-6 are used for header
information) and down to row 450+ (where there is a blank row before other
totals and stuff) and the number of rows will vary each time the export is
run. For each row, I need to pull out certain information from various
columns - for example numbers from columns F:K, a date from column M, more
numbers from Z:AJ, and the result of a SUM formula in column AS. In total I
have 60 columns to extract, so these are just examples. These need to be
written to a sheet/file in consecutive columns. This file will need to have
a predetermined row of header information at the top.
I'm hoping that a few pointers will get me going and I will be able to
finish it off myself, avoiding any likely issues such as dates and formulas
being converted. I'm using Excel 2004. All suggestions greatly appreciated!
Thanks.