Dear All,
Please refer attached worksheet having row numbers.
I wanna copy these row number cells to another workbook.
which syntax should i use in offset formula to copy these cells.
Regrads
Gulam Dastgir
Dear All,
Please refer attached worksheet having row numbers.
I wanna copy these row number cells to another workbook.
which syntax should i use in offset formula to copy these cells.
Regrads
Gulam Dastgir
From your rather vague instructions:
=OFFSET(Sheet1!$A$1,Sheet1!B3,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear Sir,
The row number i write down for understanding only. What if these row numbers are not available and we have to directly copy these cells in another workbook.
As I implied in my first post to this thread, you are being much too vague. I have no idea of what you mean by "What if these row numbers are not available and we have to directly copy these cells in another workbook." We are not mind-readers! Please provide a sample of what you really want.
Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired results are also shown (mock up the results manually).
3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
4. Try to avoid using merged cells as they cause lots of problems.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
Dear Mam,
Hopefully attached file will clear you my query more lucidly.
Regards
Dastgir
so in results what are we finding
the ROW corresponding to the VALUE
OR
VALUE corresponding to the ROW
??
I need these value from the other sheet and these value are corresponding to row number of the attached sheet. I only noted down the row number for the sake of ready reference only
Sorry - still not clear. Can you give us a mock-up of before and after, showing how the row numbers are relevant?
Oh ho
Look. there two worksheets in this the attached workbook ws1. One names values and second named results.
I want to copy values from "value" worksheet to "result" worksheet.
These values are in cell A106, A198 & A290 and so on in "value" worksheet. Since the row number of these cells are differing by common number "92" , therefore it possible that we may define a offset function for copies these cell. But I am confused how to define the "row" value in offset function where starting cell is A106 and other cells are differing by "92".
To exemplify the resultant worksheet, i just link these cells in "result" worksheet with row number. But i want to define offset function to return these values.
Maybe this in A2 drag copied down::
=OFFSET(value!A$106,(ROWS(A$1:A1)*92)-92,0)
wow-la.
Bang on target.
thanks a lot
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks