macro - cut/paste

Hello can somebody help with the following problem please? I'm trying to create a macro which I will then attach to a button. Macro steps: 1. Select next available row after row 3 on 'sheet2' 2. Insert current time of day into column B on selected row 3. Copy cell C7 from 'sheet1' and paste...

Good day, I am carrying out an analysis of data submitted. the nature of the analysis is to seek variances in the data. one of the variances is multiple submissions on the same data. what I am aiming to do, is to cut all the first occurring duplicates to the bottom of the data. I have already...

I have searched for hours and can't find what I'm looking for so hope someone can help me. I have a table of data (A25:G55) to indicate outstanding orders of a product. They are in order of when each order was placed, so not in any specific numerical order. What I want to be able to do is...

Hi there, I'm having trouble figuring this one out, I'd like to include this code in a macro that sorts some information out for me, but for the life of me can't find a code that will just select a column on the left/right without putting the exact cell name, which is not what I want. Here's...

Hello all, Trust you're good. I got this script from Kutools that allow me to split data into sheets. For example I need to split 1 sheet of 5000 rows into 5 sheets of 1000 rows. My issue is that when splitting the sheet, it decrease the rows by 1000 only (sheet 1 5000 rows, sheet 2 4000 rows...

Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...

I'm sorry in advance if the answer is painfully obvious, but I am not very knowledgeable when it comes to macros. I am attempting to copy the contents of cell "C2" and paste it a line above the first line in "textbox2" or a line below the last line in "Textbox 2" while keeping the text that is...

Hi there. Complete VBA and Macro novice here and I have trawled the internet trying to find a solution. I have a basic spreadsheet with 2 sheets, titled 'Active' and 'Complete'. In Sheet 1 (Active) I have data in columns A - I. Column I shows a status as either Active or Complete. I want...

I currently have multiple sheets for storing records of payments (things to be Pay and CantPay). I am trying to write a macro that will copy and paste Cells A:M on every row where column T = "Resolved" on the CantPay sheet (where the next empty row is the next row where "a" & row-number = blank)...

Hello, I have row of data in many columns. I am looking to copy values from alternate columns of this row and paste in next row. Is there any macro written to do this? Thanks!

Hi, Can some excel genius help me out? I have multiple worksheets, lets say Sheet1 to Sheet 10 Depending on the Value in Column A, the whole row should be moved to the first empty row in the respective sheet. E.g: Value A --> Sheet 1 Value B --> Sheet 2 Value C --> Sheet 3 ….. However...

Hello, I saw this post by DK340; I need a macro that will loops through each value in column (K:K) and if the value, for example K1, is equal to "Credit Card", it needs to find the value in column B of the same row (in this example B1) and copies this value and then pastes this into cell A19...

Hi, I'm looking for a code/macro to modify Data1 in such a way so that it resembles the final result as shown in Data3 below: Data1: <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="6" style="text-align: center;"></colgroup><tbody> A B C D E F G H...

hey, I have a macro that creates a diagram and copies it to another file.. my code looks like this one: 'create diagram: ActiveSheet.Shapes.AddChart2(227, xlLine).Select ActiveChart.SetSourceData Source:=Range( _ "'Tabelle1'!$F$3:$F$722")...

I have a workbook that has a running master list of job candidates. In the master list there are columns such as candidate, recruiter, location, and other general information. One of the columns contains status information such as "offer extended", "offer accepted", "reneged", "declined", etc...

<tbody> down votefavorite I hope you can help. I have a some code below which works fine. What it does is opens up a dialog box allows a user to select an excel file, once this file is selected. The code looks through the column headings find the Text "CountryCode" then cuts this column puts...

Hi All, I have a table from columns A to K with no specific number of rows as this can vary. Row 1 is the header of the table. In column B, row 2, I have a name and the cells under are blank up to the next name and so on. I would like to seperate the table based on the intervals in column b...

Hi Guys, I was wondering if anyone can help me as I dont know if this is possible. I was wondering if anyone knows can use VBA to : 1. Copies values from Sheet 1 A1,A2,A3,B1,B2,B3,C1,C2,C3 into E11:E14 2. Then Copies this range E11:E14 into Sheet 2 A1:L1000 3. But each time it did copy...

Hi all, I really new to macros and I'd like to ask for assistance in using macro in Excel. I'l like to be able to search all the columns of a worksheet using keywords from a column from another sheet. If it gets a hit from the list it would move the whole row to a new worksheet so that...

Hi All, I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368. The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet...