paste based on value

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

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

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

screenshot windows

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

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

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

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

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

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

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

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

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