paste cell

  1. L

    Paste data into first blank cell after a specific row

    I have a worksheet that has a 7 row header (some rows are blank). I am copying data from 3 different tables and need to paste it into the first blank cell after row 7. One thing to note is I also need to be able to specify the column to paste into as the data in the table isn't in the same...
  2. L

    Copy and Paste visible cells only

    Hi All, I'm trying to copy and paste visible cells only. for instance; I have columns A to Z but I columns C to H hidden When I use Alt+; or Find & Select>Go To Special>Visible Cells Only it selects only the visible cells. I can see the perforated line separating the columns. However when I...
  3. T

    Paste password from spreadsheet after hyperlink is clicked

    Hi, I have a spreadsheet in Excel 2010 that contains a list of appx 1000 managers. Each manager on the list has a hyperlink to their spreadsheet in our directory. The spreadsheet also contains the password for each of the managers spreadsheets. The process today is for the end-user to...
  4. C

    Issues with copy and paste of all things

    Hi there, first time posting a problem on here so please be kind.... I am having a problem copying data from one file to another in Excel. This issue is unique to the destination file as when I create a new Excel document the problem does not present itself. I'm loathed to start from scratch...
  5. RCONDADO

    Paste Only Values on the Visible Cells in Two or More Collumns

    Hi friends! To paste only values on the visible cells, i use the following macro: <tbody> Sub Copy_Filtered_Cells() Dim from As Variant Dim too As Variant Dim thing As Variant Dim cell As Range 'Selection.SpecialCells(xlCellTypeVisible).Select Set from =...
  6. M

    How to construct a loop - find cell A by content, but paste cell B into another workbook.

    Hey guys, I've been lurking in the existing threads, but not sure how to approach it yet. Should be straightforward, but I'm not very competent with syntax. Consider this table. <tbody> Patient id - 336 Diagnosed Diabetes Type 1 Age 32 Insurance number GP notes text Patient id - 118...
  7. mcraven1971

    Copy rows from one worksheet into another worksheet leaving a blank row in between

    I have been racking my brain trying to figure out a quick way to resolve an age old issue I have. I currently have a workbook with 3 worksheets in it. The first worksheet is the reporting sheet, the second is before data, and the last is after data. On the reporting sheet, cell A1 is equal to...
  8. A

    Copy cell that contains values other than zero using macro in excel

    Hello everyone. I'm a new Excel 2007 user and desperately in need of help regarding macro programming. Right now, I have one worksheet that consists of several columns (A to J) with quite a number of rows as well. I desperately in need of help in building a macro that would enable me to...
  9. L

    livernut

    I need some vba code to be able to copy and paste data from one sheet to another making sure the date at the top of the column is the same. :confused:
  10. B

    Macro code for pasting the cell.

    Hello. I am a new user. I was trying to copy the sum from sheet1 to sheet2 in the same work book with macro. I was using this code: Range(Sheets(1).Rows(36), Sheets(1).Rows(36)).Copy Destination:=Sheets(2).Range("A36") It works fine. The only problem is it is copying the formula, but not the...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    • Started by jreed5535
    • Replies: 32
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    • Started by mikie1881
    • Replies: 21
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top