Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro that reformats data in excel spreadsheet
I need help creating a macro that reformats my data in excel and places it on
a new worksheet within the same workbook. It will use relative addressing so that it can convert new lines of data. Data must be reorganized before it can be imported into a database. Thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro that reformats data in excel spreadsheet
Start of by using the macro recorder to record the steps done manually. Then
change to relative addressing. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "L Hill" wrote in message ... I need help creating a macro that reformats my data in excel and places it on a new worksheet within the same workbook. It will use relative addressing so that it can convert new lines of data. Data must be reorganized before it can be imported into a database. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to send excel spreadsheet | Excel Discussion (Misc queries) | |||
Create Macro to Copy Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Excel Mobile reformats Time entries | Excel Discussion (Misc queries) | |||
Appending data from one spreadsheet to another using a macro | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |