Here is a solution. ( https://excelfox.com/forum/showthrea...ll=1#post14728 )
It uses the way of getting the required rows in the original first worksheet before , that are needed in
_ the first worksheet after,
And
_ in the new worksheet
Here are some notes in support of solution:
https://excelfox.com/forum/showthrea...ll=1#post14717
Before:
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Worksheet: 1-Sheet1
Row\Col A B C D E F G H I J K 1Exchange Symbol Series/Expiry Open High Low Prev Close LTP 2NSE ACC EQ 1265 1265 1246.5 1275.3 1247 22BUY 1167.611 3NSE ADANIENT EQ 151.85 165.45 151.4 151.85 152.35 25BUY 141.0465 4NSE HDFC EQ 1805 1826 1805 1809.3 1786.05 1330BUY 1624.03 5NSE HDFCBANK EQ 985 988.4 970 991.85 971.85 1333BUY 854.6115 6NSE HEROMOTOCO EQ 2316 2345 2300 2292.25 2311.8 1348SHORT 2024.154 7NSE HINDALCO EQ 145.9 147.45 142.45 146.95 143.6 1363BUY 119.9375
After
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Worksheet: New Worksheet
Row\Col A B C D E F G H I J K 1Exchange Symbol Series/Expiry Open High Low Prev Close LTP 2NSE ADANIENT EQ 151.85 165.45 151.4 151.85 152.35 25BUY 141.0465 3NSE HDFCBANK EQ 985 988.4 970 991.85 971.85 1333BUY 854.6115 4NSE HEROMOTOCO EQ 2316 2345 2300 2292.25 2311.8 1348SHORT 2024.154 5NSE HINDALCO EQ 145.9 147.45 142.45 146.95 143.6 1363BUY 119.9375
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Worksheet: 1-Sheet1
Row\Col A B C D E F G H I J K 1Exchange Symbol Series/Expiry Open High Low Prev Close LTP 2NSE ACC EQ 1265 1265 1246.5 1275.3 1247 22BUY 1167.611 3NSE HDFC EQ 1805 1826 1805 1809.3 1786.05 1330BUY 1624.03
Macro here: https://excelfox.com/forum/showthrea...ll=1#post14728
Similar Post
https://www.mrexcel.com/board/thread.../#post-5527494
Bookmarks