+ Reply to Thread
Results 1 to 6 of 6

Macro to add row and past values on new worksheet.

  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    25

    Macro to add row and past values on new worksheet.

    I need to automate some tasks in my workbook.
    Let me explain. In one worksheet I have a web query updated daily.
    I need to copy different row values from the query, into a new sixth row, on each of the 20 sheets.

    Is there a way to make this a single event instead of 20?

    Any help with the code?
    I found http://www.mvps.org/dmcritchie/excel/insrtrow.htm is of great help but I don’t get 99% of the instructions. Can’t distinguish functions from variables in most cases.

    Bruno
    Last edited by VBA Noob; 10-17-2008 at 02:17 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862
    If you post a sample file showing what you've got and what you're trying to do, I'll take a look for you ... MM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

  3. #3
    Registered User
    Join Date
    05-16-2006
    Posts
    25

    Exclamation

    Any help pointers examples are appreciated.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    MM has asked you to post an example of what you want. Your explanation is not clear enough.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    05-16-2006
    Posts
    25
    Here's what i've been able to crunch from other examples.
    Can you help me select all 20 sheets or make this a simple macro to run?

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Last edited by VBA Noob; 10-17-2008 at 02:17 AM. Reason: Added code tags

  6. #6
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862
    I may not have understood your purpose exactly, but here's what I think you're trying to do: I assume from your example that you have as many rows in INTRADAY from row 7 onwards as you have sheets. It looks like you're copying from row 7 down, a row at a time and putting that in the 6th row of any sheet that is not INTRADAY. You haven't attached a workbook so I can't be sure, but it looks like each row is specific to a sheet; i.e. there must be a sheet reference in a cell of the row you're copying? However, I'll just present an example here as if INTRADAY is sheet 1; the data in row 7 goes to the next sheet; row 8 to the one after that, and so on. Anyway ... try this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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