paste to another sheet

  1. B

    VBA - How do I cut and paste a row to another worksheet when 2 cells both say Yes

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

    Copy value of cell in sheet(1) IF next cell in Sheet(2)is not blank. Paste data into next blank cell of Sheet(2) Col F

    Hi all, I tried to summarize it with the title. I have two sheets I'm working with that i'll use index references for. I want to paste the value in cell "E1" from Sheet(1) to every cell in Col F of Sheet(2) if the adjacent cell in Sheet(2) Col A has a value. In other words: I have a name...
  3. S

    Excel VBA: Refer Cell Value and Offset just specific Columns from another Sheet

    Good Day All Excel MVPs, I know its sounds repeated subject, but I have been trying to get bits and pieces from different threads and post, but failing to get results as per my need. I am in a situation, where I am tired of searching further. I need to print Invoice before that I would require...
  4. S

    copy the values from one sheet and pasting it to other skipping rows

    Hi, I am new to VBA. I am trying to do one thing regarding copy and paste. Here is my question. I want to count the number of values in the column A of sheet1 and want to paste them in the column D of Sheet 2 skipping 7 rows. pattern goes like: sheet1.A2 copy and pasted to sheet2.D2 sheet1.A3...
  5. 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...
  6. A

    Copy cell that contains values other than zero using macro in excel

    Hello everyone. I'm a new Excel 2007 user and desperately in need of help regarding macro programming. Right now, I have one worksheet that consists of several columns (A to J) with quite a number of rows as well. I desperately in need of help in building a macro that would enable me to...

Watch MrExcel Video

This Week's Hot Topics

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
Top