Hi,
I have a row of values (let´s say from A1 to Z1) in my sheet "Sheet1". I am search now for a formula that copies this row to a my sheet "Sheet2" and mirrors the cells in this row, meaning that the cell A1 in "Sheet1" is the cell Z1 in "Sheet2", the cell B1 in "Sheet1" is the cell Y1 in "Sheet2", etc.
Does anyone has an idea how to do this? Many thanks in advance.
try this in Sheet2 A1:
=INDEX(Sheet1!$A1:$Z1,27-COLUMNS($A1:A1))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi benishiryo,
thanks a lot for your reply. I tried your formula, but I just got a value in A1 of "Sheet2", whereas the other cells (i.e. B1, C1, etc.) were left blank. How could I handle this?
Here is a file that employs Ben's proposal. Seems to work as expected. If you are getting different results then it may help us trouble shoot if you could utilize the instructions in the banner at the top of the page to upload an .xlsx file that illustrates the issue.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc,
thanks a lot for your reply. Your .xlsx file meets my problem pretty well. There is just one issue. In “Sheet2”, you plug in the formula in all cells between cell A and cell Z. However, I can just use cell A in “Sheet2” for a formula, but need to get values in all cells between cell A and cell Z. I have attached for this an .xlsx file. (Background for this: In “Sheet1”, the row has a dynamic length based on an underlying data source. Thus, the row always starts in cell A, but sometimes goes to cell Z and sometimes goes to cell BQ, etc.)
Any idea how to solve this? Many thanks
Your Message
Put this formula in A1 and copy it out to DZ1 ( i chose DZ1 as it seems to be greater than your maximum number of entries)
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks