Hi All,
I am attaching the sheet with query. I tried to mentioned what I am looking for. Kindly someone can help me.
I have to sheets one is called "Report" and other called "Sheet 1".
I have to copy the data from the sheet 1 to the report sheet. I appreciate if you can advise some formula which is can help me to fill easily.
Otherwise it's taking so much of time.
Thanks for your support.
Warm Regards
The file you attached has no values in Sheet1 column C. It just has #NAME errors,, becasue we cannot accessthe external data. Please amend and re-post!!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry but what is the basis of what you are trying to do? Explain in words and walk me through it, please?
for instance, what does Sheet1 /A6/C6 mean?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Actually, in the PV Cell the value comes from the C6 of Sheet1.
Purpose of mentioned this whole path is to explain someone who I have to matched the data for this cell.
I hope this explanation will help you.
Thanks for your support
Sorry, Waqari - it makes no sense to me, either. As Ford has said, you need to talk us through what you are trying to do. Please copy and paste as values the results of the formulae on the other sheet so that we can see what sheet 1 is referring to.
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.
But there's NOTHING in C6 or C-anything!!!!
Based on what? What are the rules/logic that says C6 goes in there and not C20 for instance? Or do you just want the contents of sheet1 repeated, row-for-row , onto Report sheet?Originally Posted by waqar1239
Remember, you know exactly what you are working with, what you want and why, but we have no clue what you are doing, you need to explain clearly to us to help us understand
Please see the attached file.
I tried to put more details which I missed in my last attachment.
Please have a look.
Regards
How do Enrolment 1, Enrolment 2, etc. relate to sheet 1? I cannot see the relationship at all ...
All the data will come from sheet 1.
Data will search on the base of "Tag Name" information.
I will explain here with the example.
Tag Name(A7) AIC-1001.
We need to fill all the information of this A7 row(AIC-1001).
C7 of report sheet (column Name = PV) will come from the sheet 1.
YOu will go to the sheet 1 and you will find the AIC-1001 in the location "A2 to A8".
From there you can see the PV/SIG ROw which is A6 of the sheet 1. Then you can copy the value of this row which is located at C6 to the report sheet at column C6 of PV.
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:AUTO 25/07/2017 FALSE
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:CO/SIG 25/07/2017 23
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:HIGHLIM 25/07/2017 34
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:LOWLIM 25/07/2017 0.99
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:PV/SIG 25/07/2017 12
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:SP/SIG 25/07/2017 87
[Functional Structure]AUP Larkana Alarms/NH3 Panel/AIC-1001:STNMODE 25/07/2017 TRUE
I hope this will help you.
Thanks
Based on the On sheet report Column A "Tag Name"
As I asked before, walk us through what you are doing. What are you looking for, where does it go, why is that selected, stuff like that. We all obviously do not understand what you want here. We are not trying to be difficult, but we cant help if we dont know what you are doing.
If you did this manually, what would you do?
step 1, you look for ..................?
step 2, once you find it, what do you do?
step 3, where does it go, and why does it go there?
That is the kind of detail we need please, otherwise help might be a long time coming
Variants of this formula will, I think, do what you want:
Adjust cell reference to starting cell & copy down.
=OFFSET(Sheet1!$C$6,8*(ROWS($1:1)-1),,,)
I just noticed columns G
=IF(OFFSET(Sheet1!$C$2,8*(ROWS($1:1)-1),,,)=TRUE,"Auto","Manual")
and H:
=IF(OFFSET(Sheet1!$C$8,8*(ROWS($1:1)-1),,,)=TRUE,"Cascade","Not Cascade")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks