Need Code For This Process.
There are 2 workbooks Uploader & Downloader. Want to create text file in specific format. So process is from download workbook – from Sheet “Start” To “Finish” Uploader workbook copy data one by one & create text file for each sheet from Downloader.
On Click Of Button “Create” - in workbook Uploader – Data
Copy Data from workbook “Downloader” From very 1st sheet after Sheet name “Start” & past to workbook – Uploader – Data – Cell A1.
Count Data range from Cell A2 to till end (ctrl+Shift+Downarrow).
Assume there is Count 500 then in sheet Text copy formula from A2 & past till A499.
Select All and create .txt file with name Workbook – Uploader – Data – C3 & save file in same location. (If same name exist then over past)
Step 5 Next Sheets till Sheet “Finish”.