macro - help

I have a sheet in excel and i need it to guarantee that a range of cells have entered data before completing the macro. I can get it to verify one cell but not all the other cells i also need verified. Sub CommandButton1_Click() ActiveSheet.Unprotect Dim nom As String Dim path As String If...

Hi all, I have a work project database and want to jump from one column to another if a certain value is entered. Specifically: In column Y (from Y3 to infinity) if the cell contains the word "Red" or "Orange" then I want to jump to column DE (corresponding row). I also want to repeat this...

Hello, My Macro is a very simple paste tool, including the unlocking of a sheet, content clearing, pasting data saved to the clipboard and then re-locking it. This works very well on my PC but it won't work on anyone elses when I send it to them to test. My code is: Sub Paste3()...

Hello all, A large part of my workday involves reviewing worksheets containing comments. Some comments are formatted perfectly whereas others need resizing. In turn I find myself doing the same activity over and over again to format them; which led me to discover this auto formatting macro...

I just setup an inventory database, an I am using the following macro to help keep the count accurate when something is added/removed. Sub Worksheet_SelectionChange(ByVal Target As Range) Dim numCell As Range If Target.Count <> 1 Then Exit Sub If Target.Value = "+" Then...

So I have three sheets "Yard", "Available spaces", and "Yard configurations" If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of...

So I have two codes that I am using to delete cells from two different sheets. I first had a button on each sheet to run the macros, but instead I would like to create one button on my third sheet that will run both macros. My first code is for Worksheet ("yard") Sub RemoveTractors()...

OK so I have a sheet that has a list of grants and basic info on those grants (Tab Info). On another sheet (Tab Financial) I have Expenditures, Revenue, and Match in column A and Months across 9. I'm trying to have a new row inserted for each section for each grant. I want to be able to run a...

Hello, I am very very new to using macros. I currently have a macro set up (I used the record macro function, like I said, very new) to hide all values in a table that equal 0 and another macro to unhide the data. I would like to be able to copy this worksheet into the same workbook and have...

Hi all, I'm brand new here so apologies if I am posing this question in the wrong place. I am moving information from an exported automated report to a new, separate worksheet. The information I need help with is regarding the date column. The automated report generates a date AND a time...

Hey guys. I am new into this VBA Macro thingy, and I would appreciate some help to complete my Excel document. No asking to do it for me :nya:, hence assist me if possible as I intend to learn it too. So, I did create a Service request form (excel xlsm) simple document, where the applicant...

I have the below values and I want to create a macro to add the duplicates and delete it. <tbody> <tbody> Apple=260 </tbody> <tbody> Orange=3 </tbody> <tbody> Banana=246 </tbody> <tbody> Apple=43 </tbody> <tbody> Mango=93 </tbody> <tbody> Banana=4...

Hello everyone, I have an difficult problem and i do not even know if this is possible in MS Excel. The question is as follows: The Excel file should automatically calculate the amount of palletlocations needed for storage. <tbody> Boxes Monday Tuesday Variation 1 0 0 Variation 2 140...

****** name="Generator" content="Microsoft Word 15 (filtered)"><style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:"Segoe UI"; panose-1:2 11 5 2 4 2 4 2 2 3;} /* Style Definitions */ p.MsoNormal, li.MsoNormal...

I have excel (xls) file with macro and works properly with errors. The weird part happen next. :warning:At the same time, I'd created a new excel file and each cell with confirmed text will prompt me an error "Can't find project or library". I'd checked through Tools/References and can't find...

I want to combine two macros which are as follows I've following macro to print letters with a data available in data sheet... Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer Sheets("Form").Activate StartRow =...

Hello everyone! I have lots of excel files, each one saved in a separated folder, that I have to copy data from them. This is the structure I have here: Folder Names: 15109 15115 16160 etc ... A total of 70+ folders Each folder has a excel (with macro file): 15109 LME.xlsm 15115 LME.xlsm...

Hi All, Here I go again requesting for help. :(:( So I have multiple workbook, which will be the dump file of the userform I made. basically what it do is track activity of each employee. This workbook called TALTracker has in itself the userform. when you open the file, the userform pops out...

I found a macro to "hide" rows that have a value <1 in them. However, occasionally, we need to go back and put values in those hidden rows. Is there a way to undue the macro or run a reverse of it? This is the macro I am using. I am also open to a better macro to accomplish what I want. Thank...

I want to find a specific text in range, if that text is present in a range then output should be yes else no <tbody> A B C D brands Keywords output should be Reason Papermate Papermate pencil Yes coz it contains Papermate (Present in column A) HP Papermate pen Yes coz it contains...