Hello again.
My problem is explaind in the attachment.
Hello again.
My problem is explaind in the attachment.
Please post your question in the narrative - not the file... the file is to aid the narrative not the other way around.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Ok so my question is this:
What I want is
When I type a number like 900015 in colum N on sheet1 i want it to be copyed here like this.
When i do that i want the info of row 2 to be copyed in row 2 in here
I know I have to use the VLOOKUP fuktion fro colum B,C,D,E,F,G,H,I
Now I'm using the formula for J that looks like this =IF(ISNUMBER(Tabela1[Nalog])="";"";LEFT(Tabela1[Nalog];7))
So this copys the value from colum N from sheet1 into colum J on this sheet.
My problem is this:
If i type the number on sheet1 in row 2 it copys it in row 2
If i type the number on sheet1 in row 3 it copys it in row 3
But if i type the number on sheet1 in row 5 i want it to copy it to the next empty row so in this cas if row 2 and 3 are filled i want it to copy to row 4 now 5.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks