Formula – ime sheeta kopiranje

22/06/2013 § Leave a comment

Како променити име листа када се формула копира

=INDIRECT(“‘”&A1&”‘!$F$1”)

У ћелију А1 треба уписати име листа (sheeta) и копирати формулу


http://support.microsoft.com/kb/213933

http://support.microsoft.com/kb/151323

http://www.softpanorama.info/Office/Excel/Reference/excel_indirect_function.shtml

http://stackoverflow.com/questions/9776229/why-doesnt-this-vlookup-formula-using-the-indirect-function-work

Требао бих да пробам овај код: http://j-walk.com/ss/excel/tips/tip63.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Formula – ime sheeta kopiranje at RheXenoR.

meta

%d bloggers like this: