sindhuja
02-05-2008, 07:03 PM
Hi all,http://www.mrexcel.com/forum/images/smilies/icon_smile.gif
Can any one help me out with my requirement.
i have a txt file which system generates automatically daily.
1) i will download the .txt file, copy the contents, paste it into the excelsheet then delimit the contents.
2)downloaded contents contains headers like INDEXING, REVIEWING and ERRORS. All i need to do is copy the contents under INDEXING and paste it to an already existing saved excel file in the sheet naed index...
similarly for reviewing and errors.. and the values will not be constant and also volumes.
i am not sure whether this can be done using macros. This, i was doing manually and if i get a coding for this it will be highly helpful.:help
Thanks in advance !!!!
-Sindhujahttp://www.mrexcel.com/forum/images/smilies/tongue.gif
Can any one help me out with my requirement.
i have a txt file which system generates automatically daily.
1) i will download the .txt file, copy the contents, paste it into the excelsheet then delimit the contents.
2)downloaded contents contains headers like INDEXING, REVIEWING and ERRORS. All i need to do is copy the contents under INDEXING and paste it to an already existing saved excel file in the sheet naed index...
similarly for reviewing and errors.. and the values will not be constant and also volumes.
i am not sure whether this can be done using macros. This, i was doing manually and if i get a coding for this it will be highly helpful.:help
Thanks in advance !!!!
-Sindhujahttp://www.mrexcel.com/forum/images/smilies/tongue.gif