deletes

Hey! I need to combine 3 spreadsheets into a big one but I dont know how long each one will be. What I have so far is a short macro that merges them together and then deletes the blank rows between each other, but his seems very clunky. Anyone has a quick fix for this? Thanks!

Good morning, I have a worksheet which links to other worksheets for its calculations. I already have a macro which deletes all external links, but I'd like one that deletes just external links from a certain worksheet, as that worksheet pulls in many values and can slow the program. The linked...

I have a vLookup that im using but when rows get deleted it changes my cell reference. Im not sure how to apply Indirect formula into my exisiting formula. I start with: =IFERROR(VLOOKUP($T$1-2,Job!$A$1:$AB$500,147,FALSE),"--") But after a few deletes I get this...

Hello, I need to convert invoices including a tons of items to Excel. When I copy the text and paste it into Excel there are several rows which are the footer. These are always the same 6 rows with a blank row in front of them. When I have 20 pages it's quite timeconsuming to delete these...

I have a data base in columns A:H max to 99999 rows, commencing from Row 10 as Header and Row 11 to 99999 as data <tbody> Col A Col B Col C Col D Col E Col F Col G Col H AAA 560 BBB 45 CCC 453 DDD 125 452 EEE 478 12...

Hi all I have a number of spreadsheets that have comments in many of the cells within them. Is there a way to copy from each spreadsheet all the comments into a spreadsheet (for totals) The problem I have is that to do this it deletes the ones already copy/pasted. There are far too many to copy...

Hi there, I have a little dilemma. I have a worksheet which has a button to import a picture into a cell. It names the picture 'Image1'... When it imports, the button disappears and is replaced with a 'delete picture' button, which deletes and resets the buttons to import again... However...

Hi, One of my staff is forgetting NOT to delete certain cell values. Example. Cell E9 has this code in it =IF(C9="","",C9+D9) When he deletes values in Row 9 he also then deletes the code that is in cell E9. Next time values are entered into row 9 the calculation does not take place as this...

Hello, I'm looking to make a button that, as part of the macro it runs, deletes itself. This is what I have so far ActiveSheet.OLEObjects("Button 1").Delete Application.Calculate Range("TimeSheet[Date(s)]").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues...

Hi, Curious if there is a way to hide or delete a row based on criteria? So if O3 says "Presented", then the whole row (3) either hides, deletes, or maybe moves to another tab. Is this possible? Thx

Hi I hope you can help me. The following macro works but it also deletes columms that partly contains the string its searching for. 'Sub Remove_columns() ' Dim wS As Worksheet ' For Each wS In ThisWorkbook.Worksheets ' With wS ' For i = .Columns.Count To 1 Step -1 '...

Hello, I am looking for a macro that deletes table rows that are completely empty. Thank you, Moluccanmom

Hi Everyone, I need a macro that looks down column D and if a cell value is "Sold" deletes that cell and the one next to it (Column C) thanks Tony

Hello, can you please help share an excel VBA macro that deletes columns F onwards except the last column. Last Column changes, it can be the column F or AZ.

Hi I'm using excel 2010 I need a macro that deletes all rows after row 10 that does not contain these special characters as shown ## and ** that are always on separate rows on a data log file I just need to strip all redundant data Thank-you in advance

The code below works fine if seperated but together I get the folllowing error message "Compiler error Invalid qualifier" The code takes a list of url from sheet2 "URL LIST" and extracts the data from IE, pasting it into sheet1, it then deletes any blank rows. I did have a delete duplicate...

I recorded a macro which does the following: 1. In sheet "Data" is deletes everything in columns A:U 2. Then is goes to sheet "All Form" and selects rows A:N and deletes everything then it unmerges all cells and then ends up selecting cell A1 When I run it it says "Compile error: procedure too...

Sorry if this has been answered before I searched and did find some similarities but nothing quite the same and wasn't able to use what i found to fix my problem. I get a spreadsheet at the start of each month that has employee turnover by manager and department problem is that i want to be...

Hi, I was wondering if someone could help me please? When a number in column A is entered, I would like the following to happen: The number 11 automatically enters in column C and 800 enters into column E. With a value in column A. Once column B is selected I'd like it to call for a userform...

Hello, I have a work book, in Excel 2010, that uses modules to build a spreadsheet template (Datasheet-C). I work off of Sheet1. When all said and done, I have a button, on Datasheet-C, that when clicked deletes all other sheets besides Datasheet-C, removes the code from Datasheet-C for the...