How to use name range..Please help to solve this issue..
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Apr 27, 2015 at 01:51 AM
Mathewmunna - May 7, 2015 at 02:19 AM
Mathewmunna - May 7, 2015 at 02:19 AM
Hello,
i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e1= range1 display namerange range1, e4 = range3 display namerange3 & so on..please help me to solve the issue
i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e1= range1 display namerange range1, e4 = range3 display namerange3 & so on..please help me to solve the issue
Related:
- How to use name range..Please help to solve this issue..
- How to increase wifi range from router settings - Guide
- Apple airtag range - Guide
- Karbikes electric bike range - Home - Apps & Sites
- Wimax frequency range - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 4, 2015 at 12:03 PM
May 4, 2015 at 12:03 PM
Hi Mathew,
Try the following code and see if we are on the right track.
Don't forget to save before running the code, so you can reload your file when some data might be overwritten.
Here is the code:
Best regards,
Trowa
Try the following code and see if we are on the right track.
Don't forget to save before running the code, so you can reload your file when some data might be overwritten.
Here is the code:
Sub RunMe() Sheets("Page1").Select For Each cell In Range("A1:A5") Application.Goto Reference:=cell.Value If Sheets("Page2").Range("A1") = vbNullString Then Selection.Copy Sheets("Page2").Range("A1") Else Selection.Copy Sheets("Page2").Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1) End If Next cell End Sub
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 30, 2015 at 11:41 AM
Apr 30, 2015 at 11:41 AM
Hi Matthew,
So you want to compare a single cell to a range of cells. Per definition they can never be equal. So when will they be equal according to you?
Best regards,
Trowa
So you want to compare a single cell to a range of cells. Per definition they can never be equal. So when will they be equal according to you?
Best regards,
Trowa
exactly page1 is input lets consider column A ... i.e a1 to a5 i will give input
like rng1, rng3, rng4, rng2, rng5. i already have named ranges(rng1, rng2..rng5) with different number of columns but equal rows. what i need output is on page2
using the input cells i.e a1= rng1 then start from cell a1.. name range i.e predefined rng1(eg: i defined on page1,G1:J6 as name range i.e "rng1", K1:M6 as "rng2", N1:Q6 as "rng3") output should be on page2 cells A1:D6 show values on "rng1" continuing E1:G6 show values on "rng3" (i.e values on K1:M6, reffering given input on page1 cell a2) and should continue checking till a5 on page1.. Hope u understand my complex reply..
Thanks TrowaD
With regards,
Mathew
like rng1, rng3, rng4, rng2, rng5. i already have named ranges(rng1, rng2..rng5) with different number of columns but equal rows. what i need output is on page2
using the input cells i.e a1= rng1 then start from cell a1.. name range i.e predefined rng1(eg: i defined on page1,G1:J6 as name range i.e "rng1", K1:M6 as "rng2", N1:Q6 as "rng3") output should be on page2 cells A1:D6 show values on "rng1" continuing E1:G6 show values on "rng3" (i.e values on K1:M6, reffering given input on page1 cell a2) and should continue checking till a5 on page1.. Hope u understand my complex reply..
Thanks TrowaD
With regards,
Mathew
May 7, 2015 at 02:19 AM