paste based on value

  1. W

    VBA - Copy data from one sheet to another, pasting in a row specified in cell

    Hi all I have looked through as many of these posts as I can find and couldn't see one which covers it. I have two sheets "DB" and "Experiment 10". In the future i'll add "Experiment 20", "Experiment 30", "Experiment 40" etc., but for now I'll stick to these two. Sheet "Experiment 10" is...
  2. A

    How do I condense this code that copies "HOURS" text to next available D field based on value

    Set sh = wb.Sheets("Hours") If sh.Range("c2") = "12" Then Set sh = wb.Sheets("Work") sh.Range("D" & Rows.Count).End(xlUp).Offset(1).Value = "HOURS" sh.Range("D" & Rows.Count).End(xlUp).Offset(1).Value = "HOURS" sh.Range("D" &...
  3. S

    Need Assistance with aMacro - Paste Destination Based on an address/Hlookup-VBA

    Thank you in advance for your assistance. I am extremely green at this. I have some data E5:E67 in Sheet1 and want to copy and paste the values to a column in Sheet 2. The column in Sheet 2 is based on the date in Sheet 1 A2. In excel, I have no problem getting the lookup to get the...
  4. D

    copy from two column then paste with additional information

    screenshot windows
  5. A

    Newbie question! Pasting records associated with SOME dates between worksheets

    Hi guys - hope everyone's well! Newbie here... :) :eeek: I have one worksheet where there are records (rows) with 4 fields (columns) for 8 days in a month, but none of the others. I have another, pre-existing worksheet where there need to be records for ALL days, even if the values returned...
  6. J

    Smart Paste Information into cells

    I have a spreadsheet with several hundred records. I would like to populate blank fields in each record with information from another record with the same value in a particular field. In the example below (blank cells have been replaced with ___), I want to populate all the blank fields in...
  7. P

    Trouble when using Paste to last line

    Hi The context, I have worksheet Costa Rica where I select data based on a multiple criteria (array) and copy it to workshet March, I was able to built in a code that partially works...because what I need is that the paste is done up to final active cell on column A of Worshet March on every...
  8. A

    Copying data to specific column - XL2010

    Hello all, I am working on a project where I am bringing data in from different sources, manipulating them into one sheet. One problem that I am encoutering, that I cannot seem to wrap my head around, is selecting a group of cells and pasting them to a specific field in another sheet. The...
  9. E

    How to Copy/Paste as Value for SpecialCells

    I am just now learning vba and am trying to replicate an index/match formula I use in Excel. Here is the excel code I use: =((IF(ISERROR(INDEX(sheet2!$J$1:$J$65536,MATCH(1,INDEX((sheet2!$M$1:$M$65536=$A7010)*(sheet2!$N$1:$N$65536=$B7010),0,1),0))),0...
  10. S

    IsDate, Paste Special Question...

    What works best? IsDate? I am semi new to VBA and have only performed basics and I have something that has stumped me. Description: This one has a bit of everything involved. I need to write/modify a VBA macro that can paste special value depending on if the date matches. In otherwords...
  11. 1

    Complex Conditional IF

    I've attached my current IF statement below. It leaves the current worksheet, goes to another, looks for a code match and if found then returns the $ amount attached to the code. It works very well. =IF(ISNA(VLOOKUP(C4,'Payment Info'!A$2:F$10000,4,FALSE)),0,VLOOKUP(C4,'Payment...
  12. C

    Need to Paste value into a row on another worksheet as specified by a MATCH formula

    Hi, I have searched extensively on here and cannot find a solution to my issue, I apologise if I have missed a potential solution and if I have missed one, a link would be much appreciated. I have data on a sheet called 'Sheet1' in columns A, B and C which contains a unique identifier, a match...
  13. I

    Copy Paste Based on a Value in a cell

    Hi, I am trying to find out an easy way to copy the value in C column, times a number which is specified in B colum, to D column. I probably could not tell my problem so let me show it. So I have such a data which is longer than 1000 rows I want to have the result column. How could...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top