created

Hi Excel group, I have a sheet that the border will not go away even when I select format, no outline. It's a light gray box. The background is white so it stands out. I used name manager and set up a formula, then inserted a picture and assigned the picture to the name that i created. The...

hi all i created a button, created with Custom UI Editor. but heere create the button for the Actual Book. i want so so do this: 1) click on button, open a File and execute myMacro. how to do this? thanks..

I can't find exactly what I need.. I need a macro that will create full copies or rows.. It would be nice for one of the VBA variables to determine how many rows to copy/create. Rows = 1 ( created 1 row of each entry ) Rows = 2 (created 2 rows of each entry )

I have a formula in K12 as seen below =IFERROR(VLOOKUP(F12,Table!A:W,23,FALSE),"") I want to modify it to look at values in both F12 and H12, so I created the following =IFERROR(VLOOKUP(F12&H12,Table!A:W,23,FALSE),"") Even though the formula did not error out (syntax must be correct), I am not...

W2:Z2 could say required, not required, or completed If the cell says "required" it will eventually say "completed" once done. If it says "Not required", then it's not required. I want cell AA2 to say "Completed" once all cells say "completed" or "Not required" or any combination thereof...

Hello Everyone, I have few questions here 1. Just like what is in the subject line, I would like to learn how can I add a scrollbar within a frame that I created as well. Please see the code I created so that I can explain it further. For counter = 0 To 10 Set MyFrame=...

I feel like I'm going crazy. Help please! I have a pivot table with a slicer. I then created a separate report with a GETPIVOTDATA formula. In one file if I use the slicer to change my filters the GPD report is updated with the change in slicer. I created a second file with different data and...

Hi there, I have created a macro to pdf certain tabs from a workbook. Easy enough but and I am looking to add an already existing pdf to the macro pdf once it is created. I currently have this code which is simply the code to create the pdf. Sub PDFReport()' ' PDFReport Macro ' '...

My Picture Org Chart created from Smart Art always starts as a square even though I set width to 1000 and height to 500. Then when I ExportAsFixedFormat to PDF it's still a square and too small. Does anyone know how to have the chart created with a landscape size and to have the PDF created also...

Hello everyone, I am trying to write a code in excel that will copy the selected email body and paste it to the excel sheet. I have merged all the cells required to fit the email and created a button for the user to click and the data to be copied over. Can anyone please help.

Hi All, I have a macro file, which on opening will create a file and save it in a folder. I have created another macro to open the above macro file. My question here is to move the file created by the above macro to a different folder. Please help. Below is my code: Sub fcr_macro() Dim...

Hi, I need a script that would break up a block of text in a cell at full stops, question marks, and exclamation marks, and create additional cells (not rows) shifting bottom cells down and inserting split sentences consecutively into created cells. So, for example, A1 Sentence 1. Sentence...

I have created a master time sheet workbook template that each individual in our office copies from a network folder on to their computer. The time sheet workbook references another master workbook containing client information that remains on the network and is edited by only one person...

I've created a splash screen that opens when the workbook opens as planned, but does not unload after the required 3 seconds, it just stays open and does not seem to call the Sub that should close it. I'm using the code Application.OnTime Now + TimeValue("00:00:03"), "UnloadSplash" , and...

I am looking for macro that will sum bolded numbers The numbers that I need sum are located in B2:D2 and I would like the total number in E Numbers are automatically bolded from a pivot table created with macro. Thank you in advance for any help provided.

I have a spreadsheet that acts as a template. I complete the template and run a macro that creates a copy of the completed template as a new sheet and renames the new sheet, it then populates a row in an index sheet and creates a hyperlink to the new tab it just created, finally it clears the...

this occurs when copying and pasting from one worksheet to another worksheet (impossible for me to confirm but I strongly believe the sheet being copied from was created in 2003 Version and is being pasted into file created in 2010 Version - if that matters. Also integrated with a database...

Hello, I'm struggling with a formula which has way too many nested IF functions. The goal is to create a priority list for the IFs. To explain further - I'm trying to extract a unique identifying number (henceforth #) given a set of conditions. The conditions are: If # is attached to...