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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top