#1
|
|||
|
|||
Streaming data to cells
Hi
My knowledge of Excel is extremely poor, I'm not even sure if what I want to do is easy or not so easy to do. The data I receive randomly changes many times in a cell I have designated for it. What I would like to do is receive the first number then move down one cell to receive the next number rather than it just replace the first number. I hope that makes sense. Parbynat |
#2
|
|||
|
|||
.
Do you have existing VBA code related to the "receiving" of the data ? Where is this data coming from ? |
#3
|
|||
|
|||
Its from a trading website.
It gives you the option to connect to excel where you can create your own stuff. The feed I am interested in is the last traded price, the designated cell for this is M12. When I click the cell the code contained there reads, ='trading website'!M12 If I put this code into a cell onto a blank sheet it replicates the same price as on sheet1. Once the LTP changes from the website it changes the value in M12, I wanted to move value1 down one cell and display value2 above it instead of replacing it. I was hoping to compile a long row of these changes if its possible |
#4
|
|||
|
|||
.
Please provide the code you are using to receive the incoming financial data. Do not include any private information. |
#5
|
|||
|
|||
Where would I find this code?
|
#6
|
|||
|
|||
Lets try a different method.
Reply back to me, as you have been doing, but before you send the message attached the workbook by clicking on the button below marked GO ADVANCED (which opens another view) then look below and click on MANAGE ATTACHMENTS. That will open a small window where you can select your workbook and upload it. Then finally send the message and the workbook. Again, do not include an confidential information in your workbook. This is a much shorter process than trying to explain how to locate the code and what to copy/paste, etc. etc. |
#7
|
|||
|
|||
Many thanks for your help.
What I want to do is just a snippet of what I'm trying to do long term. I think my best bet would be to spend some time learning excel rather than asking for help all the time |
#8
|
|||
|
|||
.
Thats ok. If you determine how to use this code, it will check for a cell to determine if it is NOT EMPTY. If it is not empty, the code inserts a blank row where the cell was located and moves all other rows down one row. So, you can change the code from A1 to M12 and hopefully it will work for your needs. Best wishes ! Code:
Option Explicit Sub IsEmptyExample1() Application.ScreenUpdating = False If IsEmpty(Range("A1")) = False Then Rows("1:1").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Else Exit Sub End If Range("A1").Select Application.ScreenUpdating = True End Sub |
#9
|
|||
|
|||
.
Please mark this thread as solved so others will know. |
#10
|
|||
|
|||
Hey thanks
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manipulating Data in Cells | Stockturn | Word Tables | 1 | 09-11-2017 04:45 AM |
Clear data from unlocked cells | wpryan | Excel Programming | 5 | 02-25-2016 10:51 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
data in some cells moving | Sherriann | Excel | 1 | 08-07-2013 06:52 AM |
WMP Streaming | frith | Word | 2 | 02-25-2013 01:17 PM |