real

Hello, I'm receiving real time power data that is updating every 10 minutes in cells E15,F15. Every time it updates the current values disappear and are replaced with the new values. I would like to record all of the values throughout the day so I can work with the data later. What I would...

I am new to VBA programming I know how to copy data from a range and paste it on another range. But I can’t figure out how to copy real time data (the data changes everyday) in a workbook located on a p-drive to another workbook that I created. Some of the cells on the real time data are blank...

I have a excel sheets like this: A B C D 1 2 3 4 5 2 3 3 4 4 5 1 1 3 3 4 I should copy the column A and B in CD like as the example. Copy only both cells contigous if not both empty. In the real sheet in column a there is a question...

Hello Community, my english isn't the best so i hope you'll understand me. I've 2 tables. Table 1 (My Master table) is full of names like Apollo, Citrus, Deng etc. In table 2 are also names and material numbers. Every month i'll get e new table 2 with maybe new material numbers. So i like to...

Hi I am learning about pivot tables. I have seen many videos/examples in the net. I wonder if you know any site/video that shows how to use pivot tables in real life examples. I want to practice how to use pivot table with someone real life examples. Thank you.

Ex: Row 1: B1=Dom, C1=Seg, D1=Ter, E1=Quar, ………………………. Column A A3=3, A4=2, A5=3, A6=1, ………………………………… Existing Names: Dom§1§=0 Dom§2§=0 Dom§3§=6.15 Seg§1§=38.30 Seg§2§=38.34 Seg§3§=58.46 Shown in the example below Ter§1§=11.78...

Hello Friends I have 2 workbooks and both workbooks have a macro which I have to run when they are opened and those macro have to keep running and to my understanding i cant run them at the same time on the same system. Workbook 1 and Workbook 2 are in a shared drive which i can access from...

I have a hyperlink on my spreadsheet that, when opened, reveals a string of numbers and letters. I need to be able to see this information real time. Is it possible to embed this string in a neighboring cell so I can refer to it? Thanks for any help on this.

Hello, everyone. I have a base with data from different years, months, counts, real or budget, etc... And i am making a Profit and Loss Pivot table in Power Pivot. On the row fieds, i have the different counts and sub counts. In the column field, i have Calculate Fields with Dax. But i...

Hi, I have an excel spreadsheet that is connected to external software and it populates in real time. I'm trying to learn how I can extract certain data from this sheet to another sheet in real time at 2 second intervals and list this information every 2 seconds so later in the day I can then...

Hello, I have the following code and I would expect it to only paste from B18 downwards but it is going higher. Dim wsFor Each ws In Sheets(Array("Consumer Discretionary", "Consumer Staples", "Energy", "Banks", "Financials excl Banks", "Healthcare", "Industrials", "IT", "Materials", _ "Real...

Is it possible to share cell data from a sheet in one workbook to another in real time? Or would I need to use Access for this?