+ Reply to Thread
Results 1 to 4 of 4

VBA code to copy a range of data based on conditions

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    81

    VBA code to copy a range of data based on conditions

    VBA code to copy a range of data based on conditions

    I have multiple tables one below the other with headings Department(Column A),Item(Column B),Sales(Column C), Effective date(Column D)
    one table could have 10 lines followed by another table with 25 lines

    Heading
    . Data
    .Data
    .
    Heading
    .Data
    .Data
    .Data
    .Data

    I want ot use a VBA code to copy the first table to the next tab for first iteration ,second table to the next tab for the 2nd iteration and so on

    Thank You so much in advance

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,972

    Re: VBA code to copy a range of data based on conditions

    Hi,

    What's the ultimate objective? What will you do once the tables are on separate sheets?

    Have you considered a single sheet with Headings all the way down column A and Data down column B, then using a Pivot Table for analysis work?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-28-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    81

    Re: VBA code to copy a range of data based on conditions

    I need to take one table at a time and Enter data into Internet explorer.

    Either I can take one table at a time to next tab or take each table to seperate tab.

    The report is available that particular format.
    Last edited by rshnkmr39; 02-18-2014 at 07:11 AM.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,972

    Re: VBA code to copy a range of data based on conditions

    So when you have the tables in separate tabs what then? You mention Internet Explorer, are you expecting Excel to copy data to a web site or are you expecting to create some code in the web based system to suck data in from Excel?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy data from raw to template based on 2 conditions
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2013, 12:13 PM
  2. [SOLVED] VBA Code to Pull data to another spreadsheet based on conditions!
    By mg87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-16-2013, 02:38 PM
  3. [SOLVED] Need ‘Set Print Area’ Code for Dynamic Print Range based on Conditions
    By dosbirn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:13 PM
  4. Help: Copy/link data from one sheet to another based on conditions
    By norvelle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2012, 10:21 PM
  5. complex macro code to select data based on given conditions
    By j.farr3ll in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2012, 07:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1