Input values from sheet to another sheet

[Jenina]

Hi all - I know we can use cross tab to input values to another sheet. I just need to know how to put those values in specific cell/column/row.

I've attached my example file. Values from sheet 1 to be pasted to sheet 2 row 8.

Thank you!

[binuacs · Accepted solution]

@Jenina One way of doing this

[Jenina]

Looks it will work! Thanks!

[Jenina]

@binuacs  Hello again, what if there are multiple columns to select and will input into consecutive rows (I8:J8, I9:J9, I10:J10 for example)?

[binuacs]

@Jenina you could try with I8:J10, it is very similar to the Excel range function

[Jenina]

@binuacs     I'm having this error 

[binuacs · Accepted solution]

@Jenina This would happen if you are trying to write more columns that are not fitting the given range, to resolve the issue you check your output fields and make sure that is fitting in your range, also make sure your output tool is configured like below

[Jenina]

@binuacs Thanks! Another question for this, what if we want to source the value from a not specific row, but from a specific section instead (like an ifvlookup/index match function in excel). 

Sample below. Instead of using last row, we want to get the fees from the "100 Variance" section as the last row will not accurately reflect what we need. Thanks!