ExcelBanter - copy and paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste (https://www.excelbanter.com/excel-discussion-misc-queries/218833-copy-paste.html)

Andrew

copy and paste

Hello,
when i'm going to copy a function:
=CERCA.VERT(A15;Dettagli!A6:G65536;6) ------- italian version
excel update the formula changing A15 to A16 and A6:G65536 to A7:G65537
but I nedd only it update A15 to A16.
can you help me please?

--
BBB

damorrison

copy and paste

On Feb 2, 7:02*pm, andrew wrote:
Hello,
when i'm going to copy a function:
=CERCA.VERT(A15;Dettagli!A6:G65536;6) ------- italian version
excel update the formula changing A15 to A16 and A6:G65536 to A7:G65537
but I nedd only it update A15 to A16.
can you help me please?

--
BBB

Check out Absolute vales, something like
=CERCA.VERT(A15;Dettagli!$A$6:$G$65536;6)

All times are GMT +1. The time now is 01:04 AM.