Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating Splitting one worksheet
We pull information from an Access database using a select query and
convert the result to Excel. Now we have to change the column widths to handle the information and separate the information by Region. Is it possible to create a macro of VBA code to help do this more effectively, change the column width on the initial worksheet and then creat worksheets for each region and populating them with their data. We moving from a monthly report to a weekly report and automation is really needed. Thanks for our help. Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating Splitting one worksheet
Frank,
Can't you edit the SQL to use "<SQL SELECT text WHERE Region=?", then ..Refresh the query. Copy/paste or Pastespecial the results to desired/new WS. Repeat for next region. As for column widths, look into .AutoFit, if that's what you mean. NickHK "FJB" wrote in message ups.com... We pull information from an Access database using a select query and convert the result to Excel. Now we have to change the column widths to handle the information and separate the information by Region. Is it possible to create a macro of VBA code to help do this more effectively, change the column width on the initial worksheet and then creat worksheets for each region and populating them with their data. We moving from a monthly report to a weekly report and automation is really needed. Thanks for our help. Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating a Worksheet | Excel Worksheet Functions | |||
Automating a worksheet in Excel 2003 | Excel Worksheet Functions | |||
automating a worksheet/workbook | Excel Discussion (Misc queries) | |||
Automating Worksheet Names | Excel Worksheet Functions | |||
Need help with automating the updating of a function in worksheet | Excel Worksheet Functions |