delete

Friends, I am developing task based database using VBA, I also developed user form similar to Data Entry (DE), * For that I need a program to auto update of SI.No in database automatically incremental immediately after invoking the DE User form using last SI.No in the (particular row)...

Hello all I have a long list of date that populates columns A:F Can I have help with code that will simply delete the data held on that particular row through columns A:F For example if cell A16 is double clicked then A16:F16 id deleted and the remaining rows beneath are all moved up to fill...

I thought I would be able to find a macro for this but could not. Pretty straight forward. "Delete Rows Where Column A Does Not Equal a Number or Numeric Value" Anyone have a solution? Thanks!

I have to delete this file But there is a condition Kill "C:\Users\WolfieeeStyle\Desktop\1.xls" Kill "C:\Users\WolfieeeStyle\Desktop\2.xls" Kill "C:\Users\WolfieeeStyle\Desktop\3.xls" If there is kill.xlsb in this path C:\Users\WolfieeeStyle\Desktop then only kill all that files and if it is...

Hi everyone! I'm sort of new here,a novice.I'v had problems with the excel for some time but the online suggestions couldn't help me as I don't know a lot of stuff. here is the deal,whenever I use a vba code. I have to clean up a list of exel on Task manager otherwise when I turn on my...

Hi, I have a need to delete many shapes on a worksheet although I wish to keep others. All of the shapes that I wish to delete are either lines or rectangles and the ones that I wish to keep are not. I had hoped the following would work, but it doess not - can anybody let me know what the...

So I'm trying to create a leave/vacation tracker for my employees/coworkers, and I want to automate the worksheet so it automatically deletes(and shifts) certain cells every day. This is so the tracker remains up to date without anyone having to physical delete the cells themselves. There is a...

Dear Experts Until yesterday the following code was working well for me. But for some reasons it has started behaving strange and deletes the column "Date" from the table. I'm unable to identify the problem so have stoped using the delete command for now. But need your help to find and rectify...

Hi, Thanks in advance, Need help to remove the value in coloumn in following sheet if only "0" coming Coloumn A 8 6 0 0 2 7 0 0 0 Formula or VBA will delete all the "0" after 7 I have also coloumn B, C, D and E

I have a combo box on my user form and I can not find it anywhere. I have used code to move it and make it colors and visible to locate it to no avail. Is there some code to just delete it so I can add a new one? Tired of looking for it. Thanks

Can anyone show me how I can delete all the rows after the last one found in column C with the criteria 'Not Available'?

Hi I need a Macro to delete rows which have 0 as value in col R between row 4 and 34 only rest of them should stay .Thank you!

Hello, Looking for VBA code to put in my Module. I have Columns A:D which can have different amount of rows each time i run the code. What I am trying to do is to look in Column D, called "TYPE" and delete and row if the cell in Column D starts with either "Green-" or "Red-".

Evening All Wondering if someone could lead me to an alternative. The below Loop deletes the row if a cell condition (Text "Test") is located in Column J, also looking to delete the 3 rows above. Coincidentally found a similar request on the forum yesterday, however unsure how to amend. Thank...

<tbody> SKU Type KW1 KW2 KW3 SUM SKU1 Actual Sales 30 41 28 99 SKU1 LY Sales 46 41 25 113 SKU1 Forecst 40 42 43 125 SKU2 Actual Sales 1084 793 2022 3899 SKU2 LY Sales 950 958 765 2672 SKU2 Forecst 871 790 1659 3320 SKU3 Actual Sales 44...

I will place the vba code in sanju.xlsm my all files are located in same place Sheet name can be anything in both the files Open the file and If cells of column C of sanju.csv matches with sheet2 cells of column C of sanju.xlsx then delete that complete row close and save the file

I have a spreadsheet with a table that is used for storing quotes that has a delete all table lines button. My supervisor needs a way to undo or restore if the delete all lines button is clicked. The quote could be up to 100 pages long, so re-entering all that information is just not practical...

Hey pro-team! Our company has a problem with copying and pasting data dumps from our ERP system into workbooks over-and-over, resulting in compounding workbook styles to the point where multiple workbooks each month hit the excel style count max (~64,000), which causes workbook crashing and an...

vba code will be placed in a seperate file all files are located in same place vba code will be placed in macro.xlsm my file name is sample1.xlsx which is closed so we have to open the the file by vba, my sample1.xlsx first sheet name can be anything in sample1.xlsx If cells in column B are...