hope

Hi! I have been working on this macro for over a month and now I am on the home stretch. I just need help with one more thing (I hope). I need to be able to find the second blank row after a pivot table to input some text. The size of the pivot table will change every time it is refreshed...

Hi I'm new to this forum and know very little about VBA. I hope to be able to get some help here with my spreadsheet. I have a workbook of 20+ exact similar worksheets. In B6:B100 of each worksheet, I need to automatically highlight any duplicates in that range as well as those across all...

Hi all. I have an extensive excel sheet with products and prices. It’s not one list. Is there a way of applying a formula to all cells that contain values and not the text cells. Note, the cells are not in a line, they are in tables spread about the page. Thanks. In hope.

Hey all, I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards... <tbody> 1 Aberdeen 2 Ashford 1 Aberdeen II </tbody> What I'm looking to do is in cell B1 have a box...

Hi, Hope this is placed in the right category. I'm struggling to make a conditional format for the following: If the person on de "Evening shift" is the same as the person the following day in de morning (the first of the 2 persons), I want to put the name in red and bold. I have uploaded a...

Hi, May I know is it possible to remove "E+02" from 3.840000E+02 to become 3.840000? I know the value is before and after is different but is it possible? Hope you guys can help me.

Hello, Hope you are all well. I love my Macro's, they're great. From time to time though, I run one of my macros and something happens that I didn't anticipate. Normally, when such a thing happens I can hit the key command Control + Z and then boom! I can undo the last action that I've done...

Hello An application windows is already opened. It is reduced when I clicked a cell in my Excel sheet. How can I recall / select it and copy the content of the clipboard. I think it could be done using the " vbNormalFocus", If so how do I know the path of the desired application. Hope I'm...

Hey all, I am creating my first vba code which will help me a lot at work. The aim of this vba code to convert excel file with many formulas, sheets and data into an excel file ready to send to the client - without only two sheets, less data and formulas. This code will help me to save a lot of...

Dear Gents, I would like to name a copied picture as following code. Would you please help me to figure out how to name the shape generate from this range A4:AH11? I hope to name it with"My picture". Many Thanks. Sub RM() Sheet7.Range("A4:AH11").CopyPicture Appearance:=xlScreen...

Good evening, I have a issue which I hope someone can solve for me . Cells E2 - G2, when a certain task is done, the user puts a "Y" into the applicable. However some users are putting in more than 1 Y into and this gives the wrong count. Is it possible to have it so that only Y can be put in...

I Have this File with Short Note inside https://www.dropbox.com/s/kq424sszpd7gu6e/Draw.xlsm?dl=0 Hope that is enough info..

I've looked at a few other posts on this subject but can't seem to get them to work as I need, so would appreciate any help you could provide. On my spreadsheet, there are several locked sheets (no passwords) with just a few cells on the first sheet to enter scores during a golf competition...

Hi, At work, we have access to certain folders depending on our job role. Currently one of my monthly jobs is to enter data into a workbook from another workbook - a direct copying process that I would love to automate to free me up to do the rest of my job! But the workbook that I'm updating...

Hi all I am looking for a Formula that would solve a problem like this: =IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY! ie If the IF requirement is...

hi, been trying to get some vb that will combine multiple workbooks that are located in various folders/locations into one master work book & hope mr excel can sort? many thanks in advance KR Trevor3007

001= 0 hits in 8 draws 002= 1 hit in 8 draws 003= 2 or more hits in 8 draws The HTML maker would not work. Hope this works. The values in columns A<B<C<D<E are in column F ranging from 1to 42 Using the criteria above I need count formulas for columns G<H<I<J<K to return those values. All...

Hi, I am looking for a formula to search Update!$EM$3:$EM$52 for the contents of E10, if found return "", otherwise return"#" hope this makes sense Thanks for any help

Hello All I am currently trying to do a 2 way lookup with unsorted data. So let's say that I want to return the value for where the value matches number 4 on my left column and G on the overhead row. So where 4 and G intersect return that value. In this case it would be 700. and the same for...

Hello, Hope you are all well. I want to understand something. Is there a way that I can set up an excel macro that will allow me to update multiple versions of the same sheet, even if it is on other computers? My situation is, I've been working with a sheet for a little while now that is soon...