dylantzips
New Member
- Joined
- Aug 17, 2018
- Messages
- 1
To start off, I am new to using VB in excel. Here is my issue: I am using DreamReport to send out plant data to an excel file every 24 hours. I am using a single, static excel file.
The problem is that by using a static file, the data is replaced every day. This is because the data is automatically placed in the same group of cells, and the previous 24 hours get overwritten. Here is how the data is placed: http://prntscr.com/kjsgo1
So, I need a script that will shift the new data, and all of the prior data down, immediately after the report adds the data from the screenshot, so that no data is overwritten.
Thanks in advance for anyone that helps! Please ask questions if I was not clear about anything.
The problem is that by using a static file, the data is replaced every day. This is because the data is automatically placed in the same group of cells, and the previous 24 hours get overwritten. Here is how the data is placed: http://prntscr.com/kjsgo1
So, I need a script that will shift the new data, and all of the prior data down, immediately after the report adds the data from the screenshot, so that no data is overwritten.
Thanks in advance for anyone that helps! Please ask questions if I was not clear about anything.