another sheet

  1. M

    Copy cells selected by user and paste to location that they select

    Hi, I have found help from the Thread the Code is Sub YesMacro() On Error Resume Next Set Ret = Application.InputBox(Prompt:="Please select a range where you want to paste", Type:=8) On Error GoTo 0 If Not Ret Is Nothing Then Selection.Copy Ret.PasteSpecial...
  2. P

    VBA to copy range data with all visible and invisible cells to another sheet

    Dear Sirs, Wish you all a Happy New Year! After doing 2 days of searching I'm here for you kind help! Requirement: I want to copy a row range of data to other worksheet. For example- Range(A1:H1) from sheet1 to sheet2. Im am using this code below to do this Sub CopyData() Dim nextrow As...
  3. C

    How to copy particular columns and paste in another sheet on vba

    Hi, I have been trying to copy certain columns of two spreadsheets based on whether or not they match a particular cell, and then paste them in the another worksheet. This is the code I have so far: Sub search() Dim i As Integer Dim j As Integer Dim k As Long Dim counter As...
  4. A

    I have multiple rows of order data need to move daily to completed order tab

    I want to use column A if there is a number 1 in column A the order is complete and needs to be moved to the last empty row in the completed order tab. I just need a macro to move all completed orders once a day and clear the data that as been moved and move all other rows left to the top of the...
  5. D

    VBA for show/hide shape based upon value in another sheet

    Hi guys, I would like to have a shape visible, if the value in cell B7 is "WE", and hidden if not. With the VBA below, I am able to do that. HOWEVER, when the content of B7 equels the value in a cell in another sheet, it does not work - only when I write in cell B7 myself and hit Enter. Can...
  6. C

    Move/Copy from column to another sheet

    Residential/nursing homes who fail to meet standards are placed on an improvement plan. We monitor against the standard throughout the lifetime of the plan. Providers can take time to progress their plans and consequently, in any month we visit we may find that a home has either "met" or...
  7. J

    Hyperlink to another sheet without naming the sheet

    Hello everyone, I am trying to create a series of hyperlinks through a loop without specifying sheet names. This is what I have so far: <CODE> Sub Main() LastCol = ActiveSheet.UsedRange.Columns.Count LastRow = ActiveSheet.UsedRange.Rows.Count For j = 2 to LastCol Worksheets(1).Hyperlinks.Add...
  8. A

    Permission denied when trying to get cell values from another sheet

    Dear All, I turn to you, because i ran into some troubles. I want to get the value from certain cell and put it into listbox. Here is the code i am using I get permission denied when the for cycle starts. If i have the values of the cells in the same sheet everything works great. Private Sub...
  9. aamir

    Search data between two date copy to another sheet.

    I have a Master_sheet with lot of data column D is DATE ([$-409]d-mmm-yy;@) & column G is (=D-today()). In O1 date ([$-409]d-mmm;@) & R1 date (=DATE(YEAR(O1),MONTH(O1)+3,DAY(O1))-1). I want is when i date any date from O1 (drop down list). Only column A, B, D, E & F data which falls between...
  10. W

    Find and copy rows in one excel file that are not in another file

    Hi, I have two excel files, the first is 'Old_tenders' and the second is 'New_tenders'. Both contain the same columns about tenders, however, New_tenders includes new rows that are not included in Old_tenders, I need to find these new rows and put them in Sheet 2 of the New_tenders file. The...
  11. W

    Find and copy rows in one excel file that are not in another file

    Hi, I have two excel files, the first is 'Old_tenders' and the second is 'New_tenders'. Both contain the same columns about tenders, however, New_tenders includes new rows that are not included in Old_tenders, I need to find these new rows and put them in Sheet 2 of the New_tenders file. The...
  12. R

    MACRO: Find a matching cell of another sheet

    I think this one's a sequel to my last thread - http://www.mrexcel.com/forum/showthread.php?t=616832 [Yeah, I know i'm really d*mb. Sorry!] credits to my saviors SteveO59L and Snakehips I'll just make this simple to understand. *Again, I have first sheet, named "SUMMARY" *On Column A, I have...
  13. E

    Moving cell w/ drop down list to a new sheet

    I've got almost one hundred cells with existing drop down lists. I need to cut each cell and move it to another sheet without having to redefine the link to the list data. How can I do that?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top