saving data from an Excel sheet to a new excel sheet

[dorjee]

hi
I want to extract som data of a sheet and save it as a new excel file. I don t know the methods to call in vba for that
would be very kind to give me a hint'

thanks

 

[dyarwood]

You mean you want to COPY and PASTE into a new spreadsheet. Do a record macro and add a new spreadsheet, copy data, switch to the new spreadsheets and paste. Then save the spreadsheet. Then go to edit the macro and you will see the code you have just created. Adjust it to suit what you need.

 

[dorjee]

yeah well, idlike to automate that but thanka anyway.
Do you know how id have to vba code to format text data in a column into number and then extract the max value? I guess i can use Value and max functions but i dont know how to wrap them into vba code(i am new to vba as you could see..)
that would be awsome to know about!

 

[dyarwood]

As your new, are you familiar with the macro recorder under tools? If so play around with that while recording change the format of a cell. Then edit the macro and you will be able to see the VBA code for the change of format. The copy and paste will work in a very similar way.