I get several excel files which have the same format and the same number of columns ( 6 columns). The number of rows differ in each file.
I need to reformat these files in a specific way as follows -
Insert a text heading at the top of the list and make it bold
Delete the last column ( column 6). List now has 5 columns
Goto the last row of the data and delete the contents in Columns 3 and Column 4
Put text "Subtotal" in Column 4 of this row
Goto next row --> Put text "GST" in Column 4
Put formula in Column 5 ( 10% of the cell above)
Goto next Row --> Put text "Total" in Column 4
Put formula in Column 5 ( sum of the 2 cells above it)
Format the last row now as bold.
As I am new to Excel would somebody help me to do a macro to cover these tasks which are repetitive for all the files.
This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.