script help

Hi, I am trying to create a macro or a script where it automatically deletes all rows that has a blank cell. When recording the script on Excel it recognizes the steps that I am doing but when I use it on a different sheet it doesnt do it properly. Please help. Name Location Sale Aaron USA...

Yea, I have no idea where to start. I have been all over google trying to figure out the structure. I have a VBA that i need to put into a script inorder to use it in AppSheet. Can you point me in the right direction? Sub ResetWeekly() End Sub Sub ClearOldDates() 'Declare variables Dim rng As...

Hello all I'm learning new things as I go and appreciate any help. I will have multiple sheets that are identical. I want to pull all the data from the sheets to the master at the end of the day. The sheets will be named C1 and C2, and this will be in reference to the work cell where the product...

Hello everyone, I am in the process of phasing out from a retail business, and one of my daily tasks is onboarding their employees. We use an excel spreadsheet for this, but it has gotten quite large. To help minimize the possibility of any new employee getting missed, I wanted to write a...

I have a small VBA script that, when I press button, checks if values in different cells are valid. If not, it displays a messagebox telling which cell is not correct, otherwise is displays a messagebox saying "Everything looks fine" It does work, but it checks one cell at a time - if 3 cells...

Hello, I am new to Excel Online scripts, and I'm trying to write a script that automatically renames a sheet based on the value in a cell on that sheet. I assume I'd want to establish a variable with "let", so I'd think it would be something like the below. The Sheet Name, ideally, would be a...

I am working on a dashboard and I am showing a box with Previous year data. Below is what I have come up with, however I am getting either an error message. or a message of no data. The data I am testing definitely has data. If I input the year I want such as 'Date', 'Date'[Year] = 2020 it will...

Hi - I need help perfecting my VBA Script for a fairly simple macro. I have duplicated names in column A, with unique values in column H. I would like to concatenate the values in column H, if column A is the same. And then delete duplicated rows, but have the coordinating concatenate value...

Quick question (I think) I have a sheet that is auto sorting my content that is working well (shown below). My issue is, I no longer manually fill column 6. The content is now auto filled from another sheet. I want to do two things. How can I set this to make sure it only shows for one sheet...

Hello there, I have a 47 (AA - AU) column table which has 8 Formulae which i need to protect from overwriting, however the table needs to have the ability to add new rows on a daily basis, I have used data validation to protect the cells, but much to my amusement you can still copy and paste...

To start off, I am new to using VB in excel. Here is my issue: I am using DreamReport to send out plant data to an excel file every 24 hours. I am using a single, static excel file. The problem is that by using a static file, the data is replaced every day. This is because the data is...

Hello, I've got a formula in A1 that I want to convert to values in A2. Seems like this is something I have to do with VBA, but I don't know anything about VBA. Care to donate a script I can use in VBA to do this? I'll do the googling to figure out how to add the script to VBA if you'd be so...

<code class="vb keyword">I have a spreadsheet displaying a list of "Topics to address" that people from different departments can add notes and updates to. I have a "last modified by" column and "date modified" column that i would like to merge and display the name, date, and time of the last...

Hello, I am currently writing a VBScript in order to schedule it to run twice everyday. The goal of the Script is to open a Read-only Excel file, execute a macro and afterwards save the file with the same name. It is extremely important that the file is saved with the same name, so I don't have...

I am trying to rewrite the following script to increase efficiency and make it easier to enter a list of files that need to be opened. The whole process utilizes the following: -Compile File (This is where all the data will be pasted from various source files). All pastes in the compile file...

I run a report everyday that puts the the word "NULLIFIED" in either column "L" or "M". I would like to create a macro that would delete the a row that has the word Nullified if nothing else appeared under the columns G, H, I, J, K, L, M, or N in that row, however if there is other data under...

Hi Everyone, I have a script that is reformatting a dataset for me however i keep getting "Run-time Error '9': Subscript out of Range". The guy who designed the code is no longer with the company so i'm attempting to spot fix the issue for the purpose of completing a project i'm working on...

Hello All, I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet. I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the...

https://drive.google.com/file/d/0B9DAeFilFvhdTmJ6YXd0ODRMeXc/view?usp=sharing ^ this is the link to the macro I am working with. Press cntl+shift+Q Press cntl+shift+W Go to tab RPA and click another cell... Then Press cntl+shift+E Press cntl+shift+R For some reason there is a glitch between...

Hello. I am new to vba scripting and any help would be greatly appreciated. I have a spreadsheet that has multiple sheets. The "User Access Form" sheet has several activex checkboxes. I would like to copy the fields that are checked to the "Info" sheet, which is currently blank. :confused: