LinkBack URL
About LinkBacks
I have 2 tabs I am working off of. Sheet1 has all my information in rows with 1 coulum blank. I would like to populate the blank coulum cell with (X-1) and it would then transfer that row of information to another tab in the location where (X-1) is.
I have 2 tabs I am working off of. Sheet1 has all my information in rows with 1 coulum blank. I would like to populate the blank coulum cell with (X-1) and it would then transfer that row of information to another tab in the location where (X-1) is.
H and welcome to the forum
Try this, copierd down and across...
=IFERROR(INDEX('Info Sheet'!$B$4:$K$9,MATCH(Templet!$A5,'Info Sheet'!$A$4:$A$9,0),MATCH(Templet!B$3,'Info Sheet'!$B$3:$K$3,0)),"")
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
I tried using your formula and nothing happened. I miss spoke earlier I have 1 info page and multiple tabs (5) that I would like to auto populate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks