I'm trying to write a formula that will take the data from Sheet 2 of my weekly dashboard and place it in the appropriate cells in Sheet 1. This would be easy but the tricky part is that every week I add a new column on Sheet 2 so I really need a formula in Sheet 1 that looks for the last column in Sheet 2 to pull through the data.
I'm having problems uploading to the forum so here's the example file:
http://goo.gl/kFtkl
Hi
Your columns have numbers or text?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
numbers
thanks
You can get the last (rightmost) number from sheet1 row 2 with this formula
=LOOKUP(9.99E+307,Sheet1!2:2)
Audere est facere
daddylonglegs, I think you're on the right track but it's not working in my situation. Can you try with my example workbook?
http://goo.gl/kFtkl
To all: I found my answer using this formula:
Please Login or Register to view this content.
You should be able to do that more simply with LOOKUP as per my suggestion
=LOOKUP(9.99E+307,'sheet 2'!7:7)
Hey on a related note: does anyone know how to write a similar formula to auto-update Sparkline graphs based on the addition of a new column in the worksheet?
You should post a new question in a different thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks