Naresh Patel
asked on
Formatting Index
Hi Experts,
I have one file which download data from web and format that data. need to add few more step in existing button "Index" after all process done.
Step 1 In .csv file - cell P1 past this text "<TICKER>,<DATE>,<OPEN>,<H IGH>,<LOW> ,<CLOSE>,< VOL>"
Step 2 in cell P2 past this formula till end =A2&","&TEXT(B2,"YYYYMMDD" )&","&C2&" ,"&D2&","& E2&","&F2& ","&I2"
Step 3 Copy column P and past to new open .txt file and save as .csv file name
Step 4 Delete original .csv file
Step 5 Next .csv
END
Version 22 File
Thanks
iNDEX-CSV.xlsx
I have one file which download data from web and format that data. need to add few more step in existing button "Index" after all process done.
Step 1 In .csv file - cell P1 past this text "<TICKER>,<DATE>,<OPEN>,<H
Step 2 in cell P2 past this formula till end =A2&","&TEXT(B2,"YYYYMMDD"
Step 3 Copy column P and past to new open .txt file and save as .csv file name
Step 4 Delete original .csv file
Step 5 Next .csv
END
Version 22 File
Thanks
iNDEX-CSV.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
May I ask last request on this WB?
yes pls
ASKER
May Now Post Link?
yes go ahead.
gowflow
gowflow
ASKER
ASKER
Thanks