conditional copy

  1. S

    Copying cells from one worksheet if their value matches cells in another worksheet

    Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...
  2. W

    VBA script for conditional copy, format & paste from workbook1 to workbook2

    <tbody> In workBook1, i have five columns (A,B,C,D,E) with data. Here, each row is a separate record & is going have unique data. sample data is given below. A B C D E 1 Q1 A1 A2 A3 A4 2 Q2 B1 B2 B3 B4 <tbody> In workBook1, when i...
  3. S

    Conditional copy from one worksheet to another, based on values in key columns

    Hello, My scouring of previous posts somehow has not turned up something close to what I am looking for. Thanks in advance for any guidance you can please lend. A simplified version: I have a 'Master' worksheet that has IDs listed in column A, starting at row 2. In 'Sheet2' of the same...
  4. A

    Conditional Copy and Conditional Paste

    Kindly see the attachments And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th...
  5. S

    Excel VBA Macro Help. Copying data from one sheet to others based on certain criteria

    Hello, I need some VBA macro help, I have been unable to figure out a good solution on my own. I currently have a workbook with 4 Sheets. Data is imported into the first sheet named Data. It contains 5000+ rows and populates data in columns A thru G. I then need to examine each row in...
  6. P

    Compared 2 conditions and copy value from another column

    Hello, I have an issue that I have been working on for a bit now, but I can't seem to figure it out. I have 2 sheets with lots of information on it. I want to compared the values from Sheet1 column A and column D to the values on Sheet2 Column A and column B and if they match copy Sheet2 Column...
  7. A

    Copy a Worksheet based on Outline

    Hello! There is a budget worksheet that has several outlines: Level 3: Has values/numbers for the details Level 2: Has formulas/(sub)totals for level 3 items Level 1: Has formulas/Totals for Level 2 items My boss wants me to create a macro that will "copy" the worksheet but: 1. Will...

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