next available row

  1. T

    Copy and paste range of data to next available row on different sheet

    Hello everyone, I have a problem that hopefully one of you smart people can help me with. I have a spreadsheet that is used for a "Action Tracker" (1st screenshot). In column F, if I choose from the dropdown and place a checkmark in the box, I would like the data in cells G, H, I and J to be...
  2. F

    SearchString,copy and paste in next sheet

    Good day, All I am using this code to look for specific Like value in a column then copy it over to next sheet and then remove the row but when it goes to copy the next row it skips a row and start but the row below Please Help. Much thanks in advance Sub SearchString() Dim c As Range Dim...
  3. Jyggalag

    Please help me edit my VBA code/formula

    Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...
  4. T

    Find next blank line then paste data

    Hi, On the Service Order tab (Link below) there is a button that runs a macro to extract certain data form the Service Order form then paste to the imported Data sheet. How can I continue to add different but new data below the last pasted entry in the Imported Data sheet? Code to find next...
  5. C

    Create new WS & copy column to new row in another WS with macro

    Thanks for stopping by, First off, I am new to VBA so I feel like what I am trying to accomplish is probably way over my head. Also, I have searched for a solution to this but can not find exactly what I need. I have a workbook that has an overview (Monthly) worksheet with value headers in...
  6. C

    VBA - Pasting multiple tables below one another with line breaks

    Hello everyone- I have been working on this for a while now so I am caving and posting here. I have some VBA code that is opening a workbook, selecting pivot tables from a given sheet in that workbook, and pasting them as special values/special formats into the original workbook. The code...
  7. J

    Macro to special paste values and transpose them to varying cells on another sheet

    I was hoping for some help creating this code. The part that is really throwing me off is having to paste values but also have them transposed at the same time. Let me know if anything is hard to follow. Any help would be greatly appreciated! 1. Copy B2 from sheet “Data Entry”, paste to first...
  8. J

    Paste values based on a condition to next availble row in different sheet

    Hello, I'm fairly new to code but can usually problem solve my way to getting it to do what I need it to. I have been trying for days and have not had any success modifying scripts to get them work. HELP! This is what I'm trying to accomplish: 1. Copy "A4" and "B4" in sheet "DataEntry" 2...
  9. X

    "next" function not working

    I wrote a macro to split a file into rows of 20 and save them each in separate workbooks. It worked the first time round. However, I'm trying the macro a few days after and it no longer works! I only get 1 file with the first 20 rows and the macro stops there. There appear to be no bugs at all...
  10. A

    Paste to next available ROW

    I need help! :( .... I have this code that pastes multiple sheets into a master sheet...it works great BUT the code copies the next sheet of data to the next available cell in the A column. This doesn't work for me when there is info in B, C, and D because it cuts that data off. How can I alter...
  11. A

    Need assistance to copy data to next empty row in another sheet

    I am new to VBA and would greatly appreciate some assistance with this. I have a spreadsheet that will take all the data in Sheet1, Column A and will copy the data into Sheet2. The macro I currently have will transpose all the data from Sheet1:Column A to Sheet2 into 9 columns, then it will...
  12. C

    copy paste from one sheet to another and store row #

    Hi, The code below is part of a LONG macro which almost works. As I continue to test it, I find things which worked by chance, rather then from good code. I think that's the problem here. I want to copy data from the INPUT sheet ("B" i) to the next available row in the DATA ANALYSIS sheet...

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
Back
Top