copy & past rows

Hi I am looking to copy/repeat data in a row, based on the dates in the columns. The week starts on Monday and ends on Sunday. Is this possible please? ABCDEFGHIJK1Absence CategoryAbsence Start DateAbsence End DateMonday DateTotal Duration (Days)Total Absence Duration (Hours)Total Absence...

Hello folks, I have a workbook with multiple worksheets that is an operator log. The operators will make entries on the worksheet several times throughout the day. I'd like to utilize a macro that they can run every time they add data that will copy the data into an identical workbook. The...

Hi all, I received a file that I need to reformat to upload to a database. The current file is setup where one row represents one client, with twelve values for financial projections for each month of next year. I need this formatted with the same attributes, except i need one row for each...

automate the Macro : Choose the "Market/channel" from the drop-down list in cells B3 and B4 of the "Breakdown" Sheet Copy the range D3:R3 until the last values Paste the results into another "sheet" Return to the "Breakdown " sheet and choose the next "market/channel" from the list. Copy the...

Hello all, I was looking for some help to tweak the code posted by Trebor76 several years ago in this thread: https://www.mrexcel.com/board/threads/vba-to-copy-row-to-another-worksheet-if-cell-value-is-found-in-a-list.1183144/ It is very close to what I am trying to accomplish now but there is...

Hi, I'm new to VBA, I have a code which is below, the code works great if my data start in column A, but my data start in column D row 2. How do I change it for column D? Private Sub CommandButton1_Click() For i = 2 To 25 If Worksheets("Today").Cells(i, 9).Value > 2 Then...

PLEASE NEED HELP I have a sheet ("Sheet D") with different column headings from ("Sheet A") except for a part numbers column. I need to be able to go to ("Sheet D") and iterate down each row for the part number and find the matching part number in ("Sheet A"). If the part number from ("Sheet...

Hey Guys, I was hoping to get a little help here with what I though would be a simple excel command, but turns out its out of my pay grade. Essentially I have a risk sheet that tracks ALL cases opened. Now out of those cases some are more concerning than other, so we watchlist them. I created...

In the midst of trying to automate a report and the final step is to take the 2 workbooks and copy all the data (excluding the header) from WB1 to the first empty row of WB2. The issue I'm having is that it when it copies from WB1 it will paste about 173 rows below the last row of WB2... not...

Hello! I'm working on a macro and i need some help. I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR. I'm giving an example below. Lets say i have the below table and my...

I'm newish to Excel and don't use it for anything hugely complex. I am using Excel 2007. I have 1 sheet with raw data with the financials of multiple companies. I have a second sheet where the formulas are executed that refer to that raw data sheet. My problem is copying and pasting rows on...

Sheet 1 Sheet 2 Sheet 3 Sheet 4 How can I copy/paste the raw data from Sheet 1 to Sheets 2, 3 and 4? I am inputting the raw data into Sheet 1 and would like to automatically copy/paste into...

Hi VBA experts, Could you help me to write a for loop of this code. The purpose of this vba code is search for sheets that matchs SheetName column in SourceFile, copy data until the last rows of entry in Columns Range of Source File to Destination File. I can do it without a loop as the code...

I think this is a tricky one. I have a sheet where I paste different amounts of rows every time I use the sheet. I want the cells below C2 to show "TEXT" only if the cells below B2 contains value as I show on the image. If I paste 6 rows below B2, I want 6 rows below C2 to show "TEXT" in every...

hello everyone, Fairly new to VBA. I'm only using simple macros. Just wanting some help with a VBA. I want to copy and paste items from the same cell which I change, into the next line after. Here's what I use so far. But I don't know how to loop it so it does the next line down. I hope that...

Hi All Simply I want to copy data entered in workbook 1 to workbook 2, after it has printed sheet 1 of workbook 2 on Mondays clear the cells of information. I am stuck mostly with clearing on Mondays. partial help would be as welcomed as a complete solution. In more depth: Workbook "Master...

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

I am trying to create a call sheet that organizes Active Leads. I am wanting to move a customer to a "Do Not Call" sheet if that selection is made. That way I have 2 separate sheets 1 for active leads and 1 for Do Not Call. But If a customer on the Do Not Call sheet changes their mind, I would...

I want to copy multiple lines from one sheet that have the same reference number into another sheet, any ideas how? e.g. all the rows that have the ref: 123 <tbody> Ref Info1 Info2 Info3 123 wer asd uio 456 ert dfg wer 123 xxy bbg yyhj 123 wer asd ffg 456 erg wer asd </tbody>

I'm working on a rather large project and one piece of it is to search for a specific column header then go down that row and search for certain values, all of which are text. It will then copy the entire row to a new worksheet. Is there an easy array search function? Below is an example of...