copy and past

  1. M

    Copy data from excel and paste into Notepad/Notepad++

    Hi there, I have data in column A on a sheet named "IM Sample". i want to take the data here and copy it into a new notepad/notepad++ file. I then wish to save the file in a specified folder and a specified name. Location C:\Users\XXXXX\Documents\ File Name - test_File.req Is this possible...
  2. X

    Help fixing a code

    Hey mr excel i'm atm working on this code: If Sheets("Counting").Range(i, "R").Value = Sheets("Overview 2014-4").Range("Q1").Value Then Sheets("Counting").Range("S:W").Row.Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If First part...
  3. M

    Macro to copy and paste stuff...and more

    Hi all, I need help coding some stuffs in Excel 2013 I have a table set up for monthly salary info input. My boss wants it to be copied and moved down the sheet for every new month. At the same time, I need to delete the non-fixed content, so that the table can be available for a new money...
  4. E

    copy range and paste on next row that date match

    what i would like to do is copy a range of data "B185:AA185" and cell "b185" has a "date/value" and paste range "B185:AA185" to the right on new page the new page would have "dates/values" going down the side of sheet and if "b185" match then paste row "C185:AA185" i would like to have the...
  5. D

    VBA - Copying a subset of rows within a Range of filtered data

    Hi, I know that the answer to this is simple, but I can't find the answer!! I have the following code: Dim rng As Range Set rng = ActiveSheet.AutoFilter.Range rng.Copy _ Destination:=Worksheets("Sheet2").Range("A1") This copies ALL of the filtered Rows into a separate worksheet. What I...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top