Deleting Particular Sheet / Range Or Selection

Oct 2, 2012

Any easy way of finding out if deleting a particular sheet / range or selection will mess up any references elsewhere in the workbook?

View 1 Replies


Range Selection Programmatically And Copy To Another Sheet

Apr 15, 2014

I want to select a range of cells (not together I.e. b2, c3,c4,g7 etc) and copy them to another sheet but I need to check which cell has been selected as I am using a check box to set a cell as true or false if ticked or not, so if ticked a certain cell will be added to the selection set to be copied.

View 7 Replies View Related

Copy Data From One Sheet To Another With Dynamic Range Selection?

Feb 21, 2011

The CRM application that we use provides output in an excel sheet "Table View 1". I want to be able to copy the data that is dumped to a sheet to another sheet. The requirements:The data output range is different. Sometimes it is 4 rows and sometimes it is 25 rows. I want a mechanism where based on the output, the formula/macro automatically copies the information to the new sheet.The first 2 rows need to be excluded when the copy is being made.

View 6 Replies View Related

Formula In Cell To Display No Of Cells In Selection (in A Range) Anywhere In Sheet

Feb 10, 2012

Can I have a formula in A1 cell to display the No. of cells in selection (in a range) any where in the sheet. Just the No. in A1 cell is sufficient

View 4 Replies View Related

Completing Range Of Cells Based On Data On Another Sheet Prompted By Dropdown Selection

Mar 23, 2014

First sheet has a client name and several cells of data along the same line. All of the data on this sheet is kept long term.

The second sheet is completed copied and deleted. In completing the second sheet the client name is selected of a drop down list and pulled from sheet one.

What I want to do and not sure if there is a way is that when I select a client and populate it on sheet two I would like the related data on that clients line from sheet one to populate to same named lines on sheet two.

if this is possible and if so provide a brief description of how it would work

View 3 Replies View Related

Deleting Multiple Non Contiguous Rows From A TABLE Based On Selection In A Listbox?

Feb 6, 2013

I have two pieces of code that perform virtually identical functions on different sets of data.Basically, the code deletes rows of data based on a selection in a listbox. One code works perfect, the other has an issue.

The Issue:

When I select a single row for deletion, or multiple contiguous rows, everything works fine. It is when multiple Non-Contiguous rows are selected that the problem occurs. I get a "Delete Method of Range Class" error.

The data for the code that doesn't work is in a defined TABLE, the date for the code that does work isn't. So I assume this is where the problem lies.

I converted the data for the code that did not work from a table to a range, and everything works fine. However, I would really prefer that this data remain a table. There is consistently going to be rows added and deleted, and a table will take those adjustments into account, whereas a named range shrinks each time I delete a row, and doesn't grow as I add rows.Here is the code that works:

'Delete Selected Offers
For r = 0 To ListBox1.ListCount - 1 [code].....

View 6 Replies View Related

Deleting Rows From Sheet 1 When Table On Sheet 2 Does Not Have Data Anymore

Jul 3, 2014

Currently, Im running a button macro. When this button is clicked, the table from "315 Employee Data" will copy the names from column C to "315" sheet B12 onwards.

Now, what i want is when I update the employee data on "315 employee data" sheet, I want "315" sheet to automatically match the names from "315 employee data", delete and add names when I add or remove employees from the column the next time i click on that button again.

After the above is achieved, when i add new employees,run the macro and it displays the updated list of names, I want "315" sheet column A to do automatic numbering.

I have attached the file for your reference.samplesample.xlsm

View 2 Replies View Related

Copying/Deleting Rows From Sheet To Sheet

Aug 2, 2007

what I need, but can't seem to string anything together for the final product. What I want to do is search one sheet, in column BQ, for the word Complete. If a cell has that word in it, I want to copy that row, paste it into another sheet, and than go back and delete that row, and continue the search until all rows have been searched. Is there a simple way to do this?

I was thinking of an auto filter, but I'm not sure it'd work how I want it based off of what I've read.

View 9 Replies View Related

Cant Pull Data From Another Sheet After Drop Down List Selection From Another Sheet

Jul 31, 2009

I have an excel workbook with two sheets. Sheet 1 has a list of people names, rank, address, and phone numbers. Sheet 2 has boxes where a user can select a last name from all last names in sheet1. What I want to happen after the user selects the last name in sheet 2 is for it to automatically fill in the rest of the data (ie Rank, First Name, Address, city, Home phone number, Cell Phone number). What do I need to do in order for this to work?. Attached is a very small example of my much larger project.

View 3 Replies View Related

Shortcut Key For Deleting Sheet

Aug 26, 2009

I want to know the short-cut keys for the deleting sheet.

View 3 Replies View Related

Deleting A Row And Transfer Them To Other Sheet

Feb 16, 2007

how to make a program on deleting a row/s and transfer the deleted row to another sheet with the use of command button? I also want to have a message box appeared confirming that the row has to be

View 9 Replies View Related

Deleting Columns A,B,C, And Row 3 To The End Of Sheet

Nov 23, 2007

I am trying to build a macro to delete the cell content for the entire A column, B column, C column. Then i would like the macro to delete the cell content from row 3 to the bottom of the sheet.

View 9 Replies View Related

Deleting Linked Sheet Causes #REF

Jan 5, 2007

I have a Main sheet that has many formula on it that link to several Data sheets. Now sometime I want to delete the data sheets and recreate them by copying a Data template sheet and remaming it to the same name as whatever my data sheet was called.

I see that this basically causes a Ref#! error in all the formula on my main sheet so when the data sheet is recreated it wont recognise it.

How can i stop it changing the formula path to Ref#!?

View 3 Replies View Related

Short Cut Keys For Deleting A Particular Sheet

Oct 23, 2008

I want to know the Shortcut key for deleting a Particular sheet(s) from the excel workbook.

View 10 Replies View Related

Macro Is Deleting My Entire Sheet

Nov 15, 2006

Sub Delete()
Dim x As Long
For x = 28 To 8 Step -1
If Range("b" & x) = "" Then _
Range("b" & x).EntireRow.Delete
Next x
End Sub

View 9 Replies View Related

Deleting A Defined Range Name?

Feb 17, 2010

Say i have a range A1:B3 and i define it as "Fruit", but then later decide i want to call it "food", or even just revert back to cell numbers. How would one go about doing this?

View 5 Replies View Related

Deleting Objects In A Range

Aug 24, 2007

I'm trying to remove gif, jpg, and xls objects from a specific range and I can't seem to figure out how to do it. I can remove all objects from the sheet or only the gif and jpg files from a range. Here is the code I've been playing with:

Sub Clear_Sigs()
Dim Sh As Shape
With Worksheets("Sheet1")
For Each Sh In .Shapes
If Not Application.Intersect(Sh.TopLeftCell, .Range("A26:E32")) Is Nothing Then
If Sh.Type = msoPicture Then Sh.Delete
End If
Next Sh
End With
End Sub

I know this code says to delete only pictures and I've tried tweeking it to do all objects but it doesn't work for just the range I want. Any help is appreciated.


View 9 Replies View Related

Deleting Range Of Cells Using VBA

Jun 12, 2009

I need to have my macro select a certain range of cells with a specific product code and delete them. What would be the code for it (product code 107). Here is what i have so far:

Workbooks.Open Filename:=fNameAndPath, UpdateLinks:=1
ActiveWorkbook.SaveAs Filename:=myStrPath1 & myStrPath2 & myFile3 & myExt, FileFormat:=xlNormal, CreateBackup:=False
Cells.Select.Range ("A78:K153")
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
ActiveWorkbook.SaveAs Filename:=myStrPath1 & myStrPath4 & myFile4 & myExt2, FileFormat:=xlCSV, CreateBackup:=False

View 9 Replies View Related

Delete Every Formula For A Sheet Without Deleting The Contents

Oct 31, 2009

How can i delete every formula for a sheet without deleting the contents?

View 5 Replies View Related

Macro For Deleting First Three Rows In All Sheets Except 1st Sheet

Apr 1, 2014

I have a excel file with more than 10 sheets and every sheet has a title on its first three rows.

I want to delete first three rows in all sheets except parent sheet .

View 4 Replies View Related

Macro Deleting Values On Wrong Sheet

Jun 6, 2009

The below code is supposed to delete data on the last sheet of the workbook HeadsetOutTimeMay.xls however for some reason it is deleting the data on HeadsetOutTime.xls What am I doing wrong?

View 8 Replies View Related

Use If / Then Statement - Deleting Range Of Cells

Jun 11, 2014

I have a sheet with thousands of rows and 45 columns and I need to delete a range of cells (G:Y) if the cell in column V = the cell in column X, and I need to do this by row. I think an if/then statement would work.

View 4 Replies View Related

Deleting Duplicates In Range Of Rows?

Mar 22, 2013

I have the following problem within Excel. I have a dataset which contains duplicate values within a column(lets say A). I need to delete these duplicates in column A for a range of rows, where the range of the rows is based on column B. So for a given value in column B, lets say 5 which is 6 rows long all beneath each other, I need to delete the duplicates in column A.

1 2234
4 2234
5 2234
4 2234
2 2234
3 2234
5 2234
5 2657
8 2657
9 2657
10 2657
8 2657
9 2657
2 2657

So above the red numbers need to be removed, automatically, since we have about 8000 rows in our dataset.

View 7 Replies View Related

Deleting Range Of Cell In Other Worksheet

Oct 2, 2011

How can i delete a range of cell in another worksheet 2? for example, i have a data in B1:F1 in sheet 2 and i want to put a button in sheet 1 which will delete the data in B1:F1 in sheet 2.

View 1 Replies View Related

Deleting Sheets Based On A Range

Nov 13, 2013

I'm pretty new to coding from scratch in VB, and I've got some code that should loop, but it doesn't. The idea eventually will be to download a spreadsheet, make a new sheet for every item in a range, and then filter for each of those items and put it in the right sheet. I have to code to create the sheets (lightly modified from something I got here)

Sub CreateSheets()
'Written by Barrie Davidson
For Each c In Sheets("FilterList").Range("b2:b74")
ActiveSheet.Name = Right(c.Value, 30)
Next c
End Sub

That's working well, so I've tried to modify it so that it will also delete sheets based on the same range. I've gotten it to delete the first item in the range, but then it stops.

For Each c In Sheets("FilterList").Range("b2:b74")
Application.DisplayAlerts = False
ActiveSheet.Name = Right(c.Value, 30)
Next c
End Sub

By the way, I don't know what the ActiveSheet.Name = Right(c.Value, 30) line does, but I put it in since it was in the code I was modifying.

View 9 Replies View Related

Loop To Delete Worksheets Stops After Deleting One Sheet

Mar 17, 2014

Sub DeleteSheetsPlease()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Application.StatusBar = "checking " & ws.Name

[code] .......

This skips "Parameters" and "About", then it deletes a single sheet (that does not match "Parameters" or "About"),

BUT THEN IT STOPS, leaving "deleting [WSNAME]" in the appstatus. It's like it skips the "Next ws" statement altogether after deleting a sheet.

I want it to keep looping on all the sheets, but that delete action seems to kill the looping...

View 2 Replies View Related

Macro - How To Remove Delete Prompt When Deleting A Sheet

Jul 22, 2013

I have a Macro which deletes a sheet called "Pre selection" with:

Sheets("Pre selection").Select

It asks me every time if I am sure and I have to click to continue. Is there any way to remove this prompt or set it to continue without my intervention?

View 3 Replies View Related

Print Selection Fit 1 Sheet.

Oct 24, 2009

i have a buttion on a whole heap of worksheets that is linked to this sub. I want it to print the range on one sheet of paper. though it will print over 4 sheets.

View 2 Replies View Related

Sheet Selection Change

Nov 13, 2008

I am getting US formatted dates with this procedure, I require UK dates, but I don't understand why its giving me US format

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If UCase(Sh.Name) "ALL BILLS" Then Exit Sub
With Target
If .Row > 5 And .Column = 19 Then
If Cells(.Row, "B") = "" Then
Application.EnableEvents = False
Cells(.Row, "S") = "CLOSED"
Cells(.Row, "E") = Format(Date, "DD/MM/YYYY")
Application.EnableEvents = True
End If
End If
End With
End Sub

View 9 Replies View Related

Listbox Selection To Sheet

Feb 4, 2007

I have Listbox on my User Form with 10 items say "A", "B","C", and so on. I wnt User to select any one item or any two or three items or even all items. Whatever user selects will be transferred in one cell only like "a","C". Is it possible to do this with listbox ?

View 3 Replies View Related

Copyrights 2005-15, All rights reserved