macros for excel

Hello Experts. Thanks for your help. I have a worksheet with 3 tables on it. Each table is named,Floor1, Floor2, Floor3. What I am trying to accomplish is write VBA code, whereI press a command button, and the table that I am working in (cell was lastselected) will have a new row created at the...

Having difficulty on what formula to use in table 2 to sum the values from the variables entered in column 1. Not sure to use macros, vlookup, or another tool? Table 1 <colgroup><col><col></colgroup><tbody> <tbody> Process Value 1 5.00 2 3.00 3 1.5 4 2.3 5 3.4 </tbody> </tbody>...

Hi all, i want to create a hyperlink to all entries in Column to open a file with the name as in cell. For Ex:- <tbody> Name Link1 link2 JOHN JOHN.PDF JOHN.JPG ROBIN ROBIN.PDF ROBIN.JPG JOY JOY.PDG JOY.JPG </tbody> and so on, I have appx 1000 such entries. I want to open these files...

I want to refer to any date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL" Because "BRL" is a Row label of a Pivot table and I want VLOOKUP to look at the code assigned for BRL. If it is text, I want excel to run the formula in BLUE...

I recorded a very simple macro and added a 'button' in order to run it. On the original worksheet, everything functions properly. However, I will be generating a new worksheet and report every week, so I'd like to be able to add the macro to future worksheets. I thought that changing the...

I have this Macro to hide/unhide rows depending on the first column value. The problem is that it examines row by row and it takes very long since the values on the columns keep changing depending on a formula. Is there a way to examine all rows at the same time and hide/unhide them in a...

Hi there! Can someone please help me with the code below? I am simplely setting values from several worksheets to update into one (really copying). I get the "Run-time error '9' Subscript out of range on VBA script"on the lines that are 'not commented out'. The lines that are commented it out...

I want to create a spreadsheet that will send a product link to amazon.com and have amazon send back certain product information to excel For example, here is a product link that would reside in the excel spreadsheet: Amazon.com: Corelle Livingware 16 piece Dinnerware Set, Service for 4...

Create a VBA Macro to select the pivot filter and uncheck "-" and "(Blanks)" I am stumped and need assistance. I created a pivot table, a chart, and pivot slicers. When a pivot slicer field is selected the pivot table below changes based on the pivot slicer criteria, but because there are "-"...

I need to copy the value in C35 to cell B35. The result should be "Good" which is defined as the difference in the values being not more than 1. Cell C35 has circular references to other worksheets. What macro can I use in cell B35 so it keeps pasting the value from C35 until the difference is 1...

Starting with this Single Level BOM table (Windows 7 Pro, Excel 2013). "Qty Per" refers to the quantity of the child needed in the Parent: <tbody> Parent Child Qty Per PART-A PART-A1 1 PART-A PART-A1121 5 PART-A PART-A2 2 PART-A PART-A222 4 PART-A1 PART-A11 2 PART-A11 PART-A111 1...

Hi guys, thanks in advance for any help here, I have a small worksheet, nothing to advanced, however I have 2 buttons in it with 2 very short Macros attached to them, when I password protect the sheet I am unable to use these buttons, I get a "pop up" screen with 4 options, "Help", "End"...

This may be a difficult question to answer, because I can't supply the exact macros I'm using but I will try to give a good description. Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each...

I have a situation where I need to populate a list using multiple drop down lists. For example list one contains dates (Feb wk 1, Feb Wk 2) and list two contains time period (8 weeks, 6 weeks). I then have a cell populated with list one meaning Cells A1:A2 would say Feb wk 1 and Feb wk 2. What...

i trying to protect my excel workbook so no one can copy or edit my work,i have successfully disable all main sources of copying my work such as,"right click" on the mouse is disabled and "save as" is also disabled. "ctrl+c" also disabled,but I've notice that when i click the menu key( context...

Ive trying to figure this out for days, I created a macro and want the macro to save my file with the info in a cell. ActiveWorkbook.SaveAs Filename:= _ "\\asshare\home$\user\Desktop\Hmda\c6.xlsx", FileFormat:=xlOpenXMLWorkbook _ , CreateBackup:=False I would like...