+ Reply to Thread
Results 1 to 2 of 2

Macro for huge input/output problem using relative reference?

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    London
    Posts
    1

    Macro for huge input/output problem using relative reference?

    I am desperately trying to finish an assignment and I am stuck...

    I am using Excel 2007 and I have a workbook with several sheets. Essentially it is a mathematical model (Sheet 'ENG'), an Input sheet ('INPUT') and an output sheet ('OUTPUT'). I have loads of arrays of data in the Input sheet and each array is 10 rows by 8 columns. Each row of input data is fed into the same cells on the ENG sheet and the output is 1 row by 6 columns. All I am trying to do is automate the input of each consecutive row of data and output to a new row every time.

    Any ideas?

    I'd really appreciate any help because I have tried a number of different permutations of absolute and relative references without any success.

    Thanks in advance!
    Last edited by frogman; 12-10-2008 at 01:20 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Lets see a sample of the workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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