1. W

    Pulling info from 2 worksheets

    Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...
  2. W

    copying data from 2 different sheets

    Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...
  3. M

    How to Stop Excel From Adding Spaces on Newlines when Copying Text Out of Program

    Hi, I'm attempting to copy an Excel cell, and paste it into another program (in this case, Adobe Analytics). However, it's inserting a space after every newline. Ex: Instead of this -It does this -And this -Etc (but instead of "-" it just does a space) When I paste it as text to MS Word, and...
  4. pliskers

    INDIRECT formula with Relative Column References

    I have a formula using the INDIRECT function to reference the name of the tab indicated in cell A11. This formula works and pulls in the indexed value in column G on that page. What I'd like to do is copy this formula across several columns and have the referenced index column change to H:H...
  5. P

    Copy one whole worksheet into another whole worksheet taking too long

    I am copying one whole worksheet into another worksheet but it is taking way too long and excel displays a "Excel not responding". Here is my code Sheets("Sheet1") .Select Cells.Select Selection.Copy Sheets("Sheets2").Select Range("A1").Select ActiveSheet.Paste I have used this code many...
  6. S

    Copy rows from one tab, to start on a specific row in another tab

    Trying to copy rows from spreadsheet named "Items", where if Column E = Yes, then those columns will copy over to spreadsheet named "Print or Email This" & paste starting in row 13 column A. The code below is isn't working for me. Sub CopyYes() Dim c As Range Dim j As Integer Dim...
  7. D

    Copy and Paste Row not working when filtered

    Hi I have the below code(below) that works off a button, to copy an entire row it works fine, however for some reason When the sheet is filtered, it just inserts a blank line, any ideas? Sub Copy_paste() Dim MyPassword As String MyPassword = "Yes" If InputBox("Please enter password...
  8. S

    Formula to copy row A down?

    Hi I need a formula that will copy the data is the first row of AFGIJKLMNOPQR down the sheet, as far down as long as there is data in column C? Can you help?
  9. Y

    Macro to copy values across rows and transposing them and add the user id

    Hi, I wonder if someone can help me with this problem with amacro. I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns. On a regular basis, I would need to able to copy all theaccount numbers that are present...
  10. J

    Extract href link from source code using VBA

    Below is the source code which i am getting after browsing a website I just want to copy link /search/Listing/45678489?source=results in excel and want to know how to click it class="details" is same for all href links that i want copy while id keep on incrementing mk:1:mk, ms:2:mk and so on
  11. N

    Copy only part of last row that has data

    I have this code: Range("A" & Rows.Count).End(xlUp).EntireRow.Copy Range("A" & Rows.Count).End(xlUp).Offset(1).EntireRow.PasteSpecial It copies the entire last row that contains data and pastes it one row below. I only want it to copy part of the row, columns A to I to be exact. How do I edit...
  12. M

    VBA to get content from internet

    Hi Need a help. In column A of sheet 1, I have links of certain section of company websites. I need to copy all the content from that section to sheet 2 of excel once all content got copied from first link move to 2nd link and copy all content and so on. however i also need an identifier...
  13. D

    Copy Cell contents to previous row.

    Hello I'm looking for a macro that will copy cell contents of column E into Previous Row as it shows in this excel sheet in my google drive sheet. " From bottom Up check for column E if it find blank cell then copy that row into above row. E.g in this sheet in column E cell e15 is blank so the...
  14. R

    Button to copy value from one cell to another

    Greetings, Hoping someone can help with a script to make a Button (form control) copy the value from cell D4 and write it into the cell which is referenced as an absolute in cell E4. I'm not sure if I'm using the right button btw. Any help appreciated :-)
  15. K

    Copy Duplicate Rows to a New Sheet

    Hi all, I am looking to copy duplicate rows from a large sheet of credit card charges. I want to copy any duplicate rows based on a string text in column "AL" on sheet "Trx List" to a sheet named "Duplicates". I'm really new to VBA so any help would be greatly appreciated! Thanks, K
  16. H

    Multiple Range Copy

    Hi - I have this code to copy rows to another sheet. I thought I could extend the range by add this code. But no, any suggestions on how I include the extra columns in the copy range? Tried this ws1.Range((ws1.Cells(thisRowA, "B"), ws1.Cells(thisRowA, "H")), (ws1.Cells(thisRowA, "K")...
  17. D

    resize for copy

    how do i adjust the following code to change the copy and paste from Range("A" & i) to ("E" & i ). i get a object doesnt support the property when i change A to E. I tried to do offset(0, 4) and get a "You cannot past this here because the Copy area and paste area are not the same size...
  18. W

    Passive / indirect formula calculation and data copy - without VBA?

    Hi Guys, i just completed my registration as I guess you are playing the Championsleague of Excel, so I think it is the best place for a special question. Think about a workbook having 2 sheets, the first sheet has multiple lines meaning multiple records with the same structure. The columns...
  19. A

    Autofilter for multiple sheets which may/may not have the data

    Hi all Ive been having some errors with this part of my code in bold. as i have this code run for 4 different sheets, each sheet will come back with different data, some sheets even with no data. this code works fine on 1 sheet, and the rest keeps getting stuck at the bolded part even though...
  20. Y

    Copy image in userform to a worksheet

    Hi, Would it be possible to have your help to get a code that allows to copy an image loaded in a user form to worksheet 4 in cells A12:N12 and M12:BL12? I have the below code but I do not know how to make it work for the range of cells where I need to insert the pictures. I would appreciate...

Some videos you may like

This Week's Hot Topics