copy & past rows

hello i have been assigned a task a vba code to copy value of the previous cell in a row to the current cell only if the current cell is empty

Hi, am having trouble looking up info, but particularly making a list that looks different from the list I extract infofrom. I have tried VLOOKUP with no success, but am working on using .find andoffset, but am having trouble making a list without leaving blank rows.<o:p></o:p> <o:p> </o:p> What...

Hello, Would you help me,Please? I would like to do the following: I would like to copy row 1 before row 2 , row 3 ... and so on. So that when I print the sheet and cut the paper, Mark will see the first raw and his own data and he is not allowed to see the data of other persons. Also, each...

So basically on a double click in any cell down column A I need to copy a row four cells wide starting on column A ending on column D. Once this happens I need the macro to then paste those four cells that used to be in a row into a specific set of cells on sheet2 but the only problem is the...

Hey there, I want a macro copying only non-zero values and pasting it to desired area. My data look like this; <tbody> Form Count PL01 2 TL03 0 PR07 4 SR02 5 </tbody> My new table should only include rows having nonzero values in Count column. Form column values are unique but...

Hi, I am using a piece of code (copied below) that I found on another forum site. This macro uses check boxes and and that are checked on sheet 1 at the click of a button will copy the row data and paste it onto sheet 2 However the issue that I am having is that I want to specify what cell in...

I do not have any experience with VBA coding and I need your help to start learning. I have two different sheets, The first one include the input from the user and should get the output as well. The second sheet has all the data. The user should input two variables D and W in the first...

Salutations!! I'm looking for a solution to this problem in vba. I'd like to take data from the chart below which is in sheet 1.... <tbody> First Name Last Name Number of Tickets Ticket Numbers Annie smith 1 1 Mari jones 2 2;3 Steve smith 3 4;5;6 Nick jones 4 7;8;9;10...

Hi, I am new to VBA and have use the below code to copy rows that meet the criteria entered when prompted. Now I am trying to tweak the code to pull in dates from column K that are less than the date entered when prompted. The code works, but is also pulling in 1/1/16+ dates also. Please let me...

Hello Everyone, I am in need of a macro that, upon a double click, copies the data in a row based on the active cell being located somewhere on that row. Once Copied I would like it to paste the selected row into the next sheet in the next empty row. The first row is D1 to J1 and then goes...

I have a bunch of expense categories and am using the macro to check if the categories are in a certain range. If they are not in the range, I need to insert a row copying the formulas from the above row and add the category. The code I am using is: RepeatCheck =...

I have a list of data in Column A. Every set of data (down the list) is always started with a "Text##" followed by numbers. My idea is to write a macro to find that "Text", and set it as a start cell, then find the next "Text", and set it as a end cell - 1 (because I only want the data before...

Hi all! Hopefully a quick question. I have a macro that with a click copies a data range from one worksheet into another, just bellow the last entry and transposes it. However I now need to change this macro. The cell references and everything remain the same, but it now needs to paste into...

Hi! First of all: great forum. Had found so much nice posts here. But now I got a problem I can´t find a solution to. I got two sheets: Sheet1 <tbody> ID Name Cat1 Cat2 Cat3 xt-12345 Product 1 LED Lights Panels xt-54321 Product 2 LED Lights Downlight </tbody> Sheet2 <tbody> ID Name...

Hi all, Basically I'm trying to take information from a massive spread and based off of three colomns of criteria have the information in all rows that meets that be copied over to an existing sheet. However, I do not want all the information in each row from the master sheet to go into the...

Hi I want to copy the whole row to the second sheet in the same workbook when the marks are 100. Please help with the code thank you very much in advance. <COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY> .Student Subject Marks xya English 100 abc Hindi 20 uhs Japanese 100...

Hello and thank you in advance...I have a large spreadsheet that is exported from an application. I need to have a macro that will find all rows for each state and copy the row into a new worksheet labeled by each state and delete the rows that it copied. I would like to do this automatically...

Hi - i currently have a piece of code that will copy the selected row and paste it right underneath. However, whenever I filter on a column and run the macro it will copy but paste blanks. There are some vlookups in some of the columns so was wondering if its possible to copy and paste exactly...

Hey Mr. Excel i have this 2 Subs, and 4 excel sheets Sub copyPasteData() Dim strSourceSheet As String Dim strDestinationSheet As String Dim lastRow As Long strSourceSheet = "Counting" Sheets(strSourceSheet).Visible = True Sheets(strSourceSheet).Select...

Hey Mr.excel I'm trying to make a macro, that take the data from my sheet "Counting" in the range from "S4;W4" and copying that data to my sheet "overview" lastrow in collumn Q:U Hope you can help me out here :)