Input values from sheet to another sheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Output
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Looks it will work! Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jenina you could try with I8:J10, it is very similar to the Excel range function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!