Re: Feb series-Day6 ,NiftySpot:5326 (+56)
Updated that SpreadSheet...... Have added a new Sheet called "Columbus"....... It would automatically format the cells for you..... You would just have to copy the desired rows from the Sheet "NSEData" and paste them to this new Sheet.....
However, don't do a simple Copy Paste...... Copy the data from "NSEData"..... Then in Cell B4 of "Columbus" right-click and under Paste Options select "Values".....
And don't worry about the columns for Bid-Ask.... Copy them too.... I have hidden these columns in new Sheet....
As I am not versed with Macros.... Couldn't make it completely mechanical..... Can anyone automate the process to do the Copy-Paste Job as well......
Hi Aditya,
Thank you.Things like Column Width,Number Format ..... can be changed
using a simple MACRO.But Background colour and Text colour involves
conditions.
Thank you.Things like Column Width,Number Format ..... can be changed
using a simple MACRO.But Background colour and Text colour involves
conditions.
However, don't do a simple Copy Paste...... Copy the data from "NSEData"..... Then in Cell B4 of "Columbus" right-click and under Paste Options select "Values".....
And don't worry about the columns for Bid-Ask.... Copy them too.... I have hidden these columns in new Sheet....
As I am not versed with Macros.... Couldn't make it completely mechanical..... Can anyone automate the process to do the Copy-Paste Job as well......