I have created a clear button on my sheet to reset certain cells to 0 etc.
However in some of the cells formulas are also being deleted. Can someone tell me how to correct this problem, leave the formulas intact.
Is there a way to lock the return value of a formula. I need my vlookup formula to return the value and leave it unchanged because the data range vlookup is pulling from will be deleted on a daily basis.
Any and all help is appreciated.
This is part of my code:
.Range(.Cells(2, 1), .Cells(2, 1).End(xlDown)).AutoFilter Field:=1, _
This code will also delete the first row (header) in my sheet. Is there a way to exclude the...
I was just wondering if anyone new a macro that deleted specific tabs based on part their name. I have a macro that creates new tabs, but every tab has "Sheet 1" in it, the later tabs have "Sheet 1 (2)", "Sheet 1 (3)", etc. I just need those tabs to be deleted at the push of a button. I...
I use a workbook with around 3 Macros (No use as of now), it had around 8 tabs. The file size is around 3.30 Mb.
This workbook is used to add products into our CRM system (after saving it to CSV) however this workbook is full of calculations (at least 30 columns which is automated using...
I am sure there is a very simple solution to this. I have a list of names across rows, underneath is a number (starting at 1). What I want to do is to have a formula that means even if a column is deleted, the number adjusts itself so that it all runs correctly.
The formula that I...
Ok, so one of our executives often works on excel files straight from email - in other words, he opens an excel file straight from an email and DOES NOT save the file before making changes. He will have 20 excel workbooks open all in READ ONLY status. Well, he worked on a READ ONLY file for...
I am getting an error message which states
"Sorry, we could not find C:\Users\Simon\Downloads\QuotesAddIn64.xll. Is it possible that it was moved, renamed or deleted"?
This file was for an add in that I unsuccessfully tried to install. I have searched my PC for the file without...
I am using the below formula but always get a reference error when I delete row 14. I always want it to reference C14 even if the row is deleted. Any idea how to incorporate an absolute or index in this formula?
Thank you to anyone who can answer this!
Deleteselected Range in selected Sheets
Cananyone help with a code that deletes a Range starting in "A7" to bedeleted in all Sheets except two in the workbook?
Rangecan vary in number of Rows.
Afterall Sheets are deleted, cell "A7" must be active on all sheets thathave been deleted...
I have this code in various cells,obvioulsy each with a different cell reference.
I select a customers name in cell B then VLOOKUP populates cells C D & E
Now column D refers to how much the customer has...
I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it.
Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used.
My issue is that the first macro that runs...
I have a macro that allows users to delete certain worksheets from protected workbooks.
The user is not allowed delete any worksheet that exists in the template.
However, there is a macro to allow the user to add a new sheet and rename it whatever they want.
They are allowed to delete...
I have a table. I once had a formula in one of the cells. I deleted the formula. I go to copy the row and past it the formulas re-appease in the new row.
Why? I keep having to delete the same formula over and over.
How can I create a macro to delete many columns.
I need the below columns deleted. I tried but failed....