loop and copy paste value

  1. Nick30075

    Generate subset table from Master table

    I have a table that looks like this: Need Col D values that have ";" present to be parsed out to create and new worksheet with the results looking like the output below. I've looked & tried but is beyond my level at this time. Any & all help is greatly appreciated! :banghead: Excel...
    • Nick30075
    • Thread
    • arrary loop and copy paste value new excel sheet parse data - vba table array
    • Replies: 36
    • Forum: Excel Questions
  2. S

    Looping and Filtering in VBA

    Hi Everyone, I am sending out Outlook appointments via a spreadsheet where all the data/information is stored. However, the issue I am running into is: when I need to send out multiple information to the same email address for a client, I want the client to get all of the information in the...
    • southcali12
    • Thread
    • filter advance filter array data columns loop and copy paste value loop code in column loop columns
    • Replies: 1
    • Forum: Excel Questions
  3. T

    Copying a range to another worksheet based on 2 conditions within the range and repeating for multiple rows?

    Hi All, I am using Excel 2007 and have a test question database that I need some help writing a macro for. In sheet 1, I have the master question list. Each row contains a question and its associated elements. Column A lists the version (A-C) of the test that the question is applicable to...
  4. X

    Loop and Copy

    I'm new to VBA and struggling with what I think should be a simple 'For' loop! I have a set of data that when exported and opened in Excel gives a list of companies and dates of when an order has been placed. The data contains the company name in column A and date of order in column B. The...
  5. C

    Loop through cells and copy cell contents to another worksheet

    Hi all, In need of some help as I'm a bit of a vba novice: I have a worksheets (entitled Summary 1, Summary 2, Summary 3 etc), I want to loop through the cells within each of the summary sheets and every time I come across a number, I want to copy that number into a new worksheet (entitled...
    • Coldfire46
    • Thread
    • loop and copy paste value loop code in column loop code in row
    • Replies: 3
    • Forum: Excel Questions
  6. A

    Unable to paste data in Do While Loop using pastevalue function

    hi All, i am new to this forum and newbie to the Excel VBA. I am trying to complie simple loop VBA code to copy paste data until it finds empty cell. Code function properly however i want data to be pasted in Value format. Below is the code. Appreciate if anyone could help me with this. Sub...

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