door

Hi, any help would be greatly appreciated. I have worksheet with multiple columns of information in it with my M column containing a lot of information at once. The information in column M always begins with "Door Surf Color:" followed by a 4-6 letter word. I want a function that will lookup...

I need to get report txt files into excel but can't figure out the best way to do this. Sometimes over 100 pages are in a single report and every page contains the headings and title info as shown below. I've highlighted the main info needed if getting the other data into cells is too...

I'm wondering if someone can please help me out in creating a template VBA I can use to "expand" a list I create for doors on different new designs we do. I tried doing a pivot table but it doesn't go as in-depth so I believe creating VBA that I can use to create the new list is best. I have...

Hello all I have in 2 columns a couple of strings in a cell Is it possible to index a master table and count how many times do they match? ex. Master table <colgroup><col><col><col><col><col></colgroup><tbody> 43706 T_C6000 Cabin Door - Glass - Deeper Door SMC00377 215404 43915 T_C6001 Cabin...

Hi There I work at a large hospital and we have an issue with our door access system in regards to cards having duplicate doors placed on cards and this is causing some not to work. I have attached a sample which shows the cards with their contents. I need to reference each cards contents to a...

Hello I'm creating a quoting system based on the A) the type of door and B) the size of door. I set and array for each door and the sizes available and the sales Price. I'm using IF the door is the style, then look at that particular array for its size and return the selling price: The...

Hi, I have another question here that hope you can assist me. I have an extract of raw data from our bundy clock containing the clock in and out of employees per day. However, I am not sure how to put it in VBA - as I only need to capture the first and latest time (e.g for Name A - 6:21 and...

I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...

Hi All I have a shape that when i run the macro, the shape gets smaller so its like its sliding open for i = 500 to 1 step -5 DoEvents worksheets("mysheet").shapes("moveleft").width = i nexi i What i want to do is have that same effect on my shape named moveright but get the shape to move...