Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

EXCEL MACROS

ragavendran
HPE Blogger

EXCEL MACROS

Hi,
I want to export data from a notepad(.txt) to an excel sheet, but such that i have some specific columns in the xl sheet already and the data must go into the respective columns and rows. How do i achieve this, can a custom macro be created for this purpose?. Please let me know how this can be done. thanks.
1 REPLY
Phil.Howell
Honored Contributor

Re: EXCEL MACROS

Tools, Macro, Record New Macro, ok

Data, Import External Data, Import Data

locate your text file
choose file type of "Fixed width"
set your field widths and data formats
select the destination cells

Tools, Macro, Stop Recording

Run the macro, and repeat until you have the desired results