J
john lawlor
I'm new to Office Suite, Excel/Access and VBA.
It would be best if the SQL server site did this but ...
Monthly, I manually and individually generate and download 29 xls from a SQL
Server web site which I can name anything I want (default is SummaryReort).
There is a complex series of taking last month's report containing the 29
sheets plus a few separately generated sheets at the front, manually
copying/moving one of the 29, copying constant information from last month's
report which is rows 13 down to row 17 to 20, pasting it into the sheet,
deleting last month's sheet, renaming the sheet and changing the tab color.
UGH!
Requirements:
combine sheet 2/tab 2 (of 10) from each of the 29 into a single xls eg xls1
make row 3 of each of the 29 sheets 27.5 units high
copy/add a range of rows/cells from another xls e.g. xls2 with 29 sheets,
including formats, at row 13 in xls1 from xl2 sheet 1 ... sheet 29 to xls1
sheet 1 ... sheet 29
copy xls1 1-29 sheet names and tab colors to xls2 sheet names and tab colors
1-29.
How would I best approach this?
Thanks,
John
It would be best if the SQL server site did this but ...
Monthly, I manually and individually generate and download 29 xls from a SQL
Server web site which I can name anything I want (default is SummaryReort).
There is a complex series of taking last month's report containing the 29
sheets plus a few separately generated sheets at the front, manually
copying/moving one of the 29, copying constant information from last month's
report which is rows 13 down to row 17 to 20, pasting it into the sheet,
deleting last month's sheet, renaming the sheet and changing the tab color.
UGH!
Requirements:
combine sheet 2/tab 2 (of 10) from each of the 29 into a single xls eg xls1
make row 3 of each of the 29 sheets 27.5 units high
copy/add a range of rows/cells from another xls e.g. xls2 with 29 sheets,
including formats, at row 13 in xls1 from xl2 sheet 1 ... sheet 29 to xls1
sheet 1 ... sheet 29
copy xls1 1-29 sheet names and tab colors to xls2 sheet names and tab colors
1-29.
How would I best approach this?
Thanks,
John