lots of data

Hi, I need help with a macro that works perfectly, but when data in sheet increases to thousands of rows, it hangs (unresposive with grayed out screen). The macro was modified/created by 'Fluff' (Thanks again!). My additions & alterations are between "Start of My test code here" and "End of...

Hi All, I'm new here, but I've used excel and macros occasionally in the last few years. Usually I've been able to figure things out from the posts and replies of others, but this time I'm stuck. So here it goes... I have 1xWB with 2xWS. WS1 has 3xColumns, WS2 has 1xColumn:WS1 <tbody> ID...

Hi everyone. I just started using excel for my new job and it's quite overwhelming because 1) the amount of data is MASSIVE and 2) my previous experience with excel was for only simple tasks. My current problem at work is that I have one master sheet with three different products showing how...

Hi, I have a worksheet with thousands of sets of data on it, being different drivers filling up with fuel. I need to take out the last fill up for every driver, but to go through and do this manually will take a very long time. Each driver has a unique identifier. Does anyone know a way where I...

So I have a lot of text that I need to have in a cell. I thought having a list box would be a good idea because it allows you to scroll down and helps in keeping the information neat. The problem arises when I try using filters, the list boxes get all over the place. Does anyone know of a...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...