Data Generator V2
Hi Expert,
pls see attached file in this file code is for new data to arrange in respective symbol but thing is that as new data added to that particular symbol sheet one row is added but my study is formula is same time come down to want to restrict adding row to volume column only & total data is up to 1500 row only if new data is 1501 then code should add new data & delete oldest one row data i.e data range from row 21 to 1500 only.
Pls see attached file
V2.xlsm
pls see attached file in this file code is for new data to arrange in respective symbol but thing is that as new data added to that particular symbol sheet one row is added but my study is formula is same time come down to want to restrict adding row to volume column only & total data is up to 1500 row only if new data is 1501 then code should add new data & delete oldest one row data i.e data range from row 21 to 1500 only.
Pls see attached file
V2.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hello akoster,
will you attain my next question excel formula merging, it is based on excel formula only not VBA Code.
Thank You
will you attain my next question excel formula merging, it is based on excel formula only not VBA Code.
Thank You
ASKER
Hi akoster,
Same workbook little modification in Code as new date data available say for the date 14 Aug 2012 & it symbol sheets data is updated till 14 Aug 2012 so then if i run the macro ctrl+o then it over past on not add one more line for the date 14 aug 2012, as it might be a case i had upload data for same date but in different time.
So pls attain next question data generator V3, i am asking you bcoz you are creator for this book and you will know much faster on this ..
Thank You
Same workbook little modification in Code as new date data available say for the date 14 Aug 2012 & it symbol sheets data is updated till 14 Aug 2012 so then if i run the macro ctrl+o then it over past on not add one more line for the date 14 aug 2012, as it might be a case i had upload data for same date but in different time.
So pls attain next question data generator V3, i am asking you bcoz you are creator for this book and you will know much faster on this ..
Thank You
ASKER
Hi Sir,
As i had raise one more question with same file - name EOD - Final,pls look in to that.
As i had raise one more question with same file - name EOD - Final,pls look in to that.
ASKER
Hi akoster,
i had not provided much detail in that question, so may no one can understand .so pls look in to that
i had not provided much detail in that question, so may no one can understand .so pls look in to that
ASKER