Hi,
First post here, please be kind.
I am using a Esignal DDE Add-in to pull some data into sheet2, Sheet1 has historical data which needs to keep updating as well.
What I want to do:
1- The incoming data into Sheet2(specific Row) has to be copied to Sheet1 based on change in value of the row in sheet2: The paste needs to be values only.
2- When the macro is started I want it to check the last data entry on Sheet1 and leave enough lines for that Data to be entered.
There is a slight problem which I can foresee in this, when I pull data without the DDE it is as per the Server Time, when I use the DDE to get the data it is as per Local Time setting on my Computer.
3- Sheet1 has some format 6 cells of data, then cells in which calculation needs to be done.
4- A few of the cells give specific output(I have used IF(And) function for this) when they have specific values I want to have a message box pop up to alert the user.
5- Most importantly I want all this to run in the background(hopefully) and on roughly 20 separate workbooks, they all have the same format.(I can combine all the various data sheets and input required into 1 workbook, not sure if it is required or not)
I wanted to know if this is possible to do?
If possible, where do I start learning how to do this(I am completely new to programming). Anyone willing to help with this project?
I have received a lot of help on another forum, but sadly it doesn't accomplish exactly what I want.
If required I can post a link to dropbox or use teamviewer, on dropbox the DDE will not show anything.
Thanks
First post here, please be kind.
I am using a Esignal DDE Add-in to pull some data into sheet2, Sheet1 has historical data which needs to keep updating as well.
What I want to do:
1- The incoming data into Sheet2(specific Row) has to be copied to Sheet1 based on change in value of the row in sheet2: The paste needs to be values only.
2- When the macro is started I want it to check the last data entry on Sheet1 and leave enough lines for that Data to be entered.
There is a slight problem which I can foresee in this, when I pull data without the DDE it is as per the Server Time, when I use the DDE to get the data it is as per Local Time setting on my Computer.
3- Sheet1 has some format 6 cells of data, then cells in which calculation needs to be done.
4- A few of the cells give specific output(I have used IF(And) function for this) when they have specific values I want to have a message box pop up to alert the user.
5- Most importantly I want all this to run in the background(hopefully) and on roughly 20 separate workbooks, they all have the same format.(I can combine all the various data sheets and input required into 1 workbook, not sure if it is required or not)
I wanted to know if this is possible to do?
If possible, where do I start learning how to do this(I am completely new to programming). Anyone willing to help with this project?
I have received a lot of help on another forum, but sadly it doesn't accomplish exactly what I want.
If required I can post a link to dropbox or use teamviewer, on dropbox the DDE will not show anything.
Thanks
