Learn how to a build a cloud-first strategyRegister Now


Data Generator V2

Posted on 2012-08-14
Medium Priority
Last Modified: 2013-06-16
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
Question by:itjockey79
  • 5
LVL 19

Accepted Solution

Arno Koster earned 2000 total points
ID: 38291784
added restriction to rows 21...1500.
I took the liberty to delete information below row 1500

Author Closing Comment

ID: 38291862
thank You too fast on reply

Author Comment

ID: 38292433
hello  akoster,

will you attain my next question excel formula merging, it is based on excel formula only not VBA Code.

Thank You
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 38299156
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

Author Comment

ID: 38301083
Hi Sir,

As i had raise one more question with same file - name EOD - Final,pls look in to that.

Author Comment

ID: 38301475
Hi  akoster,

i had not provided much detail in that question, so may no one can understand .so pls look in to that

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question