U
Ultsun1
Hi All,
I need to create a macro for an excel spreadsheet that will do the
following:
Provider List Macro:
1. Delete first 8 rows
2. Delete All columns except for A, B, C, D, I, and L
3. Find Row that contains = "Elimination Totals" under Column C; and
delete that row and every row below it.
4. Expand all of the remaining rows and columns so that all the rows
are visible and all columns are expanded as necessary.
5. Import this macro into Access, and run it every time a user clicks
the "Upload Spreadsheet" command button on the Upload Form.
I will need this macro to be created in Access as I will be importing
the excel spreadsheets one at a time and then the macro should make
the formatting changes and import the remaining six columns to a table
(and add one additional field - 'Fiscal Year')
If anyone knows how to do this, i would appreciate some help with
this.
Thanks,
Ultsun1
I need to create a macro for an excel spreadsheet that will do the
following:
Provider List Macro:
1. Delete first 8 rows
2. Delete All columns except for A, B, C, D, I, and L
3. Find Row that contains = "Elimination Totals" under Column C; and
delete that row and every row below it.
4. Expand all of the remaining rows and columns so that all the rows
are visible and all columns are expanded as necessary.
5. Import this macro into Access, and run it every time a user clicks
the "Upload Spreadsheet" command button on the Upload Form.
I will need this macro to be created in Access as I will be importing
the excel spreadsheets one at a time and then the macro should make
the formatting changes and import the remaining six columns to a table
(and add one additional field - 'Fiscal Year')
If anyone knows how to do this, i would appreciate some help with
this.
Thanks,
Ultsun1