Track Deleted Row Or Column
Sep 13, 2006How would I write this in vb. If a row or column deleted in sheet1 insert in sheet2 the date it was deleted, the coloumn or row cell name?
View 9 Replies
ADVERTISEMENT
Keep Reference To A Cell When Column Is Deleted
Nov 28, 2007I have a spreadsheet in excel with scheduling information, each group of data (job) is made up over 2 columns and 6 rows and is in a block (this is so it is easy to view and manouvre)
I have a link in another worksheet that extracts information from the cell if a criteria in the group is met!
At the end of each day I need to delete the columns (B and C, which make up that day) in the schedule.
When I do this all the references in the other worksheet are messed up, even though the next day is moved to columns B and C.
I would like the link to the other worksheet to automaticaly recognise the new values in column B and C as the reference.
Formulas Change When Column/row Is Deleted. How Can I Stop That
Nov 11, 2006I have a spreadsheet that holds the NHL schedule for the season. (See thumbnail)
In the picture I've highlighted the formula I use to determine how many games each team has over the next 7, 14, 21 and 28 days. What I've been doing is deleting the column for each day after that day has passed. (So tomorrow, I'll delete column K, and all the other days will move up one. Sunday will become column K)
My problem is that the formula =7-COUNTIF($K3:$Q3,"—") in cell G3 will read =7-COUNTIF($K3:$P3,"—") after I have deleted Saturday, and thus will only count 6 days worth. (The 14, 21 and 28 columns will only count 13, 20 and 27 as well.) Is there any way I can write this formula so that it stays as K3:Q3? Right now each day I modify the 4 formulas for the 1st team and then copy/paste then over the other 30, but this is rather tedious.
How To Create Log To Track Time To Second Column
Dec 20, 2013Time. What formula do I use?
6:30AfterBreakfast
7:30AfterBreakfast
8:00AfterBreakfast
8:30AfterBreakfast
9:00AfterBreakfast
9:30AfterBreakfast
10:00Before Lunch
11:00Before Lunch
12:00Before Lunch
13:00Before Lunch
14:00Before Lunch
14:30After Lunch
14:45After Lunch
15:00After Lunch
16:00After Lunch
17:00After Lunch
18:00After Lunch
18:30After Dinner
18:45After Dinner
19:00After Dinner
19:30After Dinner
Conditional Formatting: Percentages To Have White Font If An Employee Is Deleted From Column A
Jan 25, 2010The entries are made in Columns A thru C. In Columns F and G I want any value over 100% to have a red background, any value less than 100% to have regular formatting, and I'd want percentages to have white font if an employee is deleted from Column A.
Here's an example of how I have the formatting set up:
Condition 1: Formula is =$E$2="" --->white font
Condition 2: Cell value is >1 ---->red background
Condition 3 Cell value is </= 1 ---->normal format
Macro Runs Fast When Rows Added / Deleted Slow When No Rows Added / Deleted
Jun 27, 2013We have created a macro that basically looks for rows that contain an "H" and hides the row if it does.
Users can add new rows throughtout the year to this spreadsheet. and based on certain criteria, an H or U will be placed in a hidden column which the macro looks at and hides any row it finds an H.
The user has to click on the button that has the macro assigned to it once they have finished working on the spreadsheet.
The problem we're finding is that for users who insert/delete rows, once they click the button it takes up to 15 seconds to run through macro (which is ok). However, users who haven't added or deleted any rows and who click the button, they have to wait upto 5 minutes (which isn't ok) for the macro ro run.
We can't figure out why the macro takes longer to run when no changes have been made?
Catch Deleted Row
May 19, 2008I want to catch if the user has deleted a row. There is a need to know when a row is deleted and what the data was in that row. So, what I'm trying to do if a row is deleted is to undo the action and then change the font of all data in that row to have the strikethrough effect. This will enable others looking at the workbook to know that the information in the row existed but is no longer relevent.
So, the code is something like this:If row deleted Then
Application.Undo
Target.Font.Strikethrough = True
End If
A Moveable Text Box That Can't Be Deleted
Apr 8, 2009I'm not sure what it's called, but in a workbook that was sent to me, when a cell is selected a text box appears with instructions in them. This is not a normal comment and I found that I cannot select it, right click it, or anything to delete them. They can be annoying as they cover up other data when the cell is selected.
View 2 Replies View RelatedKeep Command Button After Row Is Deleted?
Jun 12, 2014how to keep a command button in a certain location even if the a row or Column is Deleted or Inserted into the worksheet?
View 1 Replies View RelatedKeep Row Height Of Deleted Row That Shifted?
Jul 16, 2014I'm using the macro below to delete a row, which works but is there a way to keep the row heights for the row that is shifting up?
[Code] .....
File Getting Too Big Because Of Arrows Not Being Deleted
Oct 3, 2013I do a weekly report for my employer. We have our tabs conditionally formatted. We then insert the corresponding arrows to show a trend to the weekly variance. After the week is up I will delete a column and add a column to the end (making it a trended view) and move the arrows by selecting and dragging all of them into its respected week. I then go on to delete several arrows throughout the worksheet. For some reason my file continues to grow in size however I am only keeping a 12 week trend. The arrows are not deleting properly and are sitting in the background, where I cannot see them. I know this bc I did "find & Select" and chose selection pane. I was wondering how I can resolve this problem or maybe delete just certain columns of arrows (objects)? I had 61,000 arrows and shouldn't have more than a couple 1,000.
View 5 Replies View RelatedButton Don't Get Deleted Completely
Dec 30, 2008I have a problem regarding buttons.I have placed buttons on my excel sheet with a regular spacing between them.These buttons are placed dynamically on the sheet and I don't know what will be their names as user can add as many as they like.Now the problem is suppose there are two buttons in the range "A1:d8" and say now i delete the this range (using range("A1:d8").entirerow.delete) then buttons do not get completely deleted .A very thin line size button still remains on the sheet.
How to remove the buttons completely......
Run Macro When Worksheet Is Deleted
Feb 26, 2009I have a macro i would like to run whenever a user deletes a worksheet...
I would like the user to be able click as normal to delete,(ie. right clicking the tab and selecting delete worksheet, or selecting delete worksheet from the menu) but would like to run my macro when they select delete.
I am using excel 07 if that helps, or i could use another version...
My macro will save a copy of the deleted worksheet as xlveryhidden as a backup..
Protecting File From Being Deleted
May 3, 2006Is there a way to protect an excel file from accidently being deleted. I have a shared workbook, and I am concerned it might be deleted from the folder.
View 2 Replies View RelatedRecover Deleted File
Jul 5, 2006How can I recover a file I deleted? I looked in the Recycle Bin and do not see it.
View 2 Replies View RelatedDetecting When A Worksheet Is Deleted
Mar 20, 2007I am working on a workbook in which you can click a button on an index page to create a new sheet in the workbook with the name "meeting" and the number meeting that it is. The new sheet is then added to the index page. I am looking for a way to detect when a sheet is deleted so I can update my index page accordingly. I need to be able to know when a meeting is deleted so I can rename all meetings after that meeting and then update my index.
View 7 Replies View RelatedDeleted Toolbar Won't Delete
Apr 20, 2007I recently downloaded a macro which came with it's own button on it's own toolbar. (I can't remember the developer, but it's called Multihide and simplifies the hiding and unhiding of worksheets).
Now, I've copied the button onto my own toolbar, and tried deleting the toolbar (by the usual method - Cursor over toolbar, R-Click, Customise, highlight toolbar name, delete) which came with the macro, and although it at first looks as though it's gone, when I next restart Excel, it's there again. I find I can't delete the button from the toolbar either, nor delete the whole toolbar.
Check If Formula Deleted
Jun 6, 2007I have a spreadsheet that has a formula placed from cells B21 through to AT21. This formula is present in the sheet 95% of the time, but occassionally the user has to enter his/her own value in one of the cells.
How can I check or the user be reminded that he/she has deleted a formula and replaced it with a user defined value. ie a message box(only as a warning) to be displayed just before the workbook is printed. The user should be able to acknowledge the message displayed and carry on.
Recover Deleted Range
Aug 31, 2007While making a spreadsheet, I somehow deleted a much needed column. I didn't notice this until after I had made several changes and 'saved as' many times. Is there any way to retrieve this data? I'm not tech-savvy.
View 4 Replies View RelatedStop File Being Deleted
Oct 16, 2007I have an Excel workbook that I do not want deleted. Is there any VBA code I can do to the document to stop this from happening? which Ic ould turn on/off?
View 4 Replies View RelatedDistribution Of Percentage If 2 Items Deleted
Feb 16, 2014AMOUNT 42400 is distributed among 6 people (C) in percentage if any of them or any 2 of them is deleted their contribution percentage need to be distributed among other.
I am attaching the example sheet... EXAMPLE.xlsx‎
Restore Excel File After Deleted?
May 26, 2014i accidentaly deleted excel file how can is recovery it
View 2 Replies View RelatedNumbers Between Questionmarks In A String To Be Deleted
Dec 26, 2009I have textstrings which have numbers between questionmarks included which I want to have deleted.
Here is an example : This ?112? is text 12 and this must ?9? be deleted.
I want to have it as : This is text 12 and this must be deleted.
Is this possible with the 'Substitute' function or is there another way to do this?
Delete Cell When Worksheet Deleted
Jul 11, 2014I want to delete a cell row in a table when I delete a corresponding worksheet with the same name as the cell.
For example, on the attached, if I delete the worksheet "Shawn" then I want row with "Shawn" deleted from the table on the "Example" tab. If I delete "Becky" worksheet then the row with "Becky" should be deleted from the table on the "Example" tab.
Delete cell when worksheet deleted.xlsx‎
To Save As All Worksheets But Modules Not Deleted
Mar 12, 2014I want the macro in this way. All sheets of the workbook. The name of the worksheet to a new workbook save as. But the modules do not get deleted.
View 1 Replies View RelatedRightclick Cell Menu Deleted
Apr 24, 2009I was customizing my rightclick cell menu, for cells in certain columns, to add some links to files and then I would delete them when right clicked in some other column.
By mistake I deleted EVERYTHING from my rightclick menu. If found where the problem was so it wouldn't happen again.
So now I am trying to put back those basic commands in the rightclick menu , but I cannot get those 'icons' that shows up on left of each command. how to get that?
Deleted Data Leaves A Trace
Dec 8, 2009I have a worksheet where I've deleted data in cells and rows. I am left with alternating rows of data and blank rows however a macro that I've been running to delete blank rows does not work on some of the rows.
To delete the data I used the Find and Replace feature and it seems that afterward the cells where this data was is now somehow marked as not completely empty. It appears empty but if I use the Control-Right Arrow combination from Column A, it skips over some cells but stops on a cell that used to contain data. If I press the Delete key it clears the cell completely and if I do that on all the cells the Ctrl-Right Arrow stops on until the end of the row, the macro works on that row...but not the next row of seemingly empty cells.
It's not spaces and there's no apostrophes and the cells are all formatted as General (Number Style) and Normal (Styles). I've even copied the format of a row of all deleted cells but that still does not completely clean out the "empty" cells. I've also run the Inspect Document command to remove what may be there but same results.
Is there something I can do to locate and remove this mysterious data?
Keep Cell Adding After Data Is Deleted
Jun 5, 2007I've a worksheet with 36 columns to keep track of a football confidence pool,I've a CF in which a W is entered in every other column from B1:AG1 and it highlites the whole column yellow,in column A is all players names,from column B2:AG2 I enter the 32 NFL teams,in row B3:AG3 I enter points from 1-16,in column AI it adds all numbers in yellow per row which gives me a weekly score,in column AJ I've the players name and there year to date points and finally in column AL it ranks the players by highest point total.
I will use this on a weekly bases for 16 weeks,what I need is for column AJ to keep adding the players points once I delete there respective numbers from rows B3:AG3 and add new ones for the following week.
Formula in cell AI3 =sumif($B$1:$AG$1,"W",$B3:AG3) copied down
Formula in cell AJ3 =A3 & " " & AI3 copied down
Formula in cell AL3 =rank(AI3,$AI$3:$AI$8,0) copied down
I also have the following macro an my sheet which allows me to use the formula in column AI3.
Function ConditionalColor(rg As Range, FormatType As String) As Long
'Returns the color index (either font or interior) of the first cell in range rg. If no _
conditional format conditions apply, Then returns the regular color of the cell. _
FormatType Is either "Font" Or "Interior"
Dim cel As Range
Dim tmp As Variant
Dim boo As Boolean
Dim frmla As String, frmlaR1C1 As String, frmlaA1 As String
Dim i As Long
If Row Deleted In Sheet1 Delete Row In Sheet2
Dec 3, 2002I have 2 sheets Sheet1 & Sheet2
Sheet1 - contains rows of data
Sheet2 - summarizes those rows
I want it so that WHENEVER a row in Sheet1 is removed that same row is removed in Sheet2 and VICA VERSA whenever a row in Sheet2 is removed that identical row is removed in Sheet1.
- this is so that data integrity doesn't get lost if someone removes a row of data in the future.
How To Get Chart Legend Back If Deleted
Apr 8, 2012So i deleted a chart legend - is there a way to get this back or do you have to start all over again?
View 4 Replies View Related
