How do I... transfer data from one worksheet to another

[sbegley73]

I'm a fairly novice excel user - from a using formulas beyond basic math and formatting pages and I'm facing a hard deadline. I have ~489 row 48 columns that may or may not be marked with "x" to signify that a separate column value needs to be transferred into that cell... I've built a master page with all the relevant info and a second page for calculations. Is there an easy way to tell sheet 2 that if sheet1!A2= "x", ... put $xx.xx in sheet2!A2


make any sense? (the "story" is... a predetermined monthly fee based on a different calculation, that needs to be added for each client that was active in any given month in the 48 month window). Clear as mud now?

Thank you all.

 

[iliace]

The additional information you would need is where the "x" is marked in Sheet1, and how you get the $xx.xx number.

For example, if your rows are marked "x" in column A of Sheet1, and the rest of the 48 columns contain $xx.xx, you could do something like this:

Sheet2!B2 =IF(Sheet1!$A2="x", Sheet1!B2, 0)

 

[L. Howard]

In sheet 2 cell A2 =IF(Sheet1!A2="x",50.45,"")

Where the 50.45 can be a cell reference like F1

=IF(Sheet1!A2="x",F1,"") and F1 = the amount you wish to have in sheet2 A2 if sheet1 A2 = "x".

Howard