Mr Excel & excelisfun Trick 9: Data In Columns VBA or Clipboard?

Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.

What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).

I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?

Thanks,

Peter Fraga
(fragapete@hotmail.com)

Hi All,

I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw

Dynamic sub tables based on a master sheet array formula

The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))

B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.

What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.

I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.

My question is...does anyone have any hints how to optimize this formula?

Thanks
Tony

I just wanted to see what you guys think of this method for creating dynamic 4 color data bars. The idea is this take the cell that will hold a target number and then base its data bar off of an adjacent cell that is either calculated or programmatically populated. As the variable cell value reaches the target value, the data bar travels along the target cell as normal, yet, also changes color as it reaches certain thresholds during its travel. A portion of this solution was obtained from http://blogs.msdn.com/excel/archive/...24/538875.aspx.

Please note examples 2 - 6 are only to show how the data will look when C14 or D14 is changed. The [list] per se will only work if just one row is the data that will be manipulated. There might be optimizations to this solution out there. If you have one please let me know...

Here is a screenshot

I have a CELL that is receiving updating numbers via RTD feed AUTOMATICALLY ie. CELL G1

My Excel 2010 Spreadsheet goes like this:
ie. total volume G1 = 1,333,783 was 1 sec ago
now. total volume G1 = 1,333,883 is right now. A trade on the RTD feed just added 100 stocks.

The real problem is:
I need to check G1 AUTOMATICALLY which is updating AUTOMATICALLY. To compare 'G1 Previous' to 'G1 at the moment' and have a VBA code see if it was added to. (The trick is that G1 has already changed upwards to 1,334,883 by now!

The easy part actually what I want to do is:
To make a single macro fire off just to insert G1 and the whole RANGE 'A1 to G1' to 'I1 to O1' and make the previous 'I1 to O1' to go down 1 row.

The real sticky part is that its RTD so via RTD ADD-IN so they don't like VBA Worksheet Functions: 'calculate' nor 'sheet change'
There is no DDE Windows application running, RTD uses the Excel Add-In infrastructure.

Just This Video For Fun

http://www.youtube.com/watch?v=0VvjrldlqI0

Hi

I'll probably get knocked over in the rush here!

I saw a spreadsheet this morning that had hidden rows & cloumns, quite normal really, but this sheet had expand & compress '+' & '-' buttons outside the cell reference bars, much like you see in Windows Explorer, these enabled you to quickly hide/unhide what I'm assuming are pre-determined sections of the sheet.

How is this done?

Rossco

"Excelover Exceloser"

I have rows of text that I want to break after the first space in the text and only the first space. I don't see how to do this outside of a special macro and I can't write VBA... ideas?

Hello. This is my first post here, so here goes.

I am running an automated macro spreadsheet that every minute or so copies data using the clipboard and pastes it. If before it gets pasted, I use the clipboard to copy something in an other spreadsheet, or other software copies something using the clipboard at the same time, the clipboard contents can get corrupted.

Is there any way to protect the clipboard contents from other programs using the same clipboard area at the same time?

I am assuming there is only one clipboard per computer? What about isolating a program and its clipboard use to a separate core perhaps? (Maybe I am dreaming there...).

I know there are many ways to copy and paste without using the clipboard, but that would make rewritting "a lot" of code. Clipboard protection for each Excel program running would be easier. If there is such a thing.

Thanks. - Chuck

Hello. This is my first post here, so here goes.

I am running an automated macro spreadsheet that every minute or so copies data using the clipboard and pastes it. If before it gets pasted, I use the clipboard to copy something in an other spreadsheet, or other software copies something using the clipboard at the same time, the clipboard contents can get corrupted.

Is there any way to protect the clipboard contents from other programs using the same clipboard area at the same time?

I am assuming there is only one clipboard per computer? What about isolating a program and its clipboard use to a separate core perhaps? (Maybe I am dreaming there...).

I know there are many ways to copy and paste without using the clipboard, but that would make rewritting "a lot" of code. Clipboard protection for each Excel program running would be easier. If there is such a thing.

Thanks. - Chuck

The engineers did a good job on PowerPivot but there seems to be an opportunity for improvement or I have not fully learned the ropes here.
I have one file of CSV data that, when it is loading, will rack up 90 million rows of data then it will crash. I have 24G of RAM and can't figure out why this is happening.

So I tried another route by creating a smaller file and then appending new data to it. Well, the clipboard is not large enought to hold the data.

My question is how can I get this data loaded into powerpivot... all 150 million rows of it.

My application is scientific in nature and requires all of this data. It is my understanding that the capacity of PowerPivot is only limited by available memory.