Reference calls error

**Headonpillow** · 11-15-2014, 09:15 AM

Hi everyone!
This is my first post ever, and I should call myself a noob. Never used excel before and now I'm getting my first troubles with this experience.
The problem is: I have two worksheets, one is called "Entrate" and the other one "Uscite". Ok now, I know how to make reference calls and it's not so difficult using the format: (Entrate!B3). My Issue is that I need to paste the function I used in "Uscite" in different lines in this worksheet and the cells in "Entrate" doesn't match.
For example, let's say I need this call in "Uscite": =(Entrate!B3*0,33) and the following must be =(Entrate!B11*0,33), but when I paste the first function it writes =(Entrate!B12*0,33) because the cells in "Uscite" and "Entrate" does not match and there is a space or plus between them.
How can I do?

**alansidman** · 11-15-2014, 09:21 AM

This should help you understand relative and absolute cell references

http://www.gcflearnfree.org/excel2013/15

**Headonpillow** · 11-15-2014, 11:21 AM

Originally Posted by alansidman

This should help you understand relative and absolute cell references

http://www.gcflearnfree.org/excel2013/15

Hi alansidman, I've read all of it but this cannot help me anyway. Maybe it's my fault and I have to be a little bit more clear.
I have the following cells: B3 and B11 in "Entrate" worksheet. In "uscite" I can make this reference call =(Entrate!B3*0,33) and it works, but when I copy and paste (function) it writes =(Entrate!B12*0,33) Instead of B11.
The problem is that in the worksheets "Uscite" the cell in which I need to make reference to B11 ("Entrate") matches with B12 cell (one cell forward) in "Entrate".
Can I correct this or I have to substitute the values manually?

Edit: It's a relative reference call, I don't need to make an absolute one.

**Headonpillow** · 11-15-2014, 01:16 PM

-----------up

**alansidman** · 11-15-2014, 01:57 PM

I clearly don't understand your issue. Please upload a sample workbook with examples of what you have and what you would like to have.

Reference calls error

LinkBack

Thread Tools

Rate This Thread

Display

Reference calls error

Re: Reference calls error

Re: Reference calls error

Re: Reference calls error

Re: Reference calls error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting "cannot run the macro" error when a sub in a macro calls another sub

Error moving or deleting cells caused an invalid cell reference - how to avoid this error

VBA - API calls for FTP

[SOLVED] reference #value error

[SOLVED] reference #value error

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions