Since you don't know VBA, then is sounds like you want someone to program
this for you.

If so, then vague descriptions about copy to a sheet, do calcs, copy back
can not be implemented in code.

Be specific

In sheet1 (Sheet name is DATA), data in columns A to M, with data starting
in A2, Headers in row 1, for each row, copy the values from Sheet2 (sheet
name CALC)

column B goes to Sheet2 Cell A9
column C goes to Sheet2 Cell F21
column D goes to Sheet2 Cell E12
etc

force sheet2 to calculate (if necessary)

Return the value in sheet2, Z21 to the same row, column N,
Return the value in sheet2, R13 to the same row, Column O

the more specific you are, the less you will have to fix on your own.

--
Regards,
Tom Ogilvy


"darkstar218 " wrote in message
...
Intermediate Excel user. No Access or Visual Basic experience
whatsoever.

Here's what I need to do. I have an Excel spreadsheet of over 10,000+
rows of data in workbook 1. I have another worksheet 2 with a bunch of
input fields and formulas.

How do I setup a Macro so that the selected fields in Worksheet 1 are
imported into the input fields in Worksheet 2 and then automatically
copies the results for each calculation back into either Worksheet 1 or
a new Worksheet 3?

Thanks.


---
Message posted from http://www.ExcelForum.com/