Forum Discussion
Excel - value from cell after adding row
Hello! Firstly, I will explain what I'm trying to do My goal is to create sheet that will get a lot of data from different excel files(same layout but different values in cells) and then with th...
Will the rest of the column below the cell with total hours be empty? If so, you can use a formula like this:
=LOOKUP(9.99999999999999E+307,'Sheet Name'!A:A)
nah, there won't be empty cell after cell with hours 😞
I attached images how it looks, maybe it will help to understand 😄
Blue Cells = data that I'm importing 😄
Before Adding Row:
After Adding Row
Blue cell with hours changed position from C22 to C23 and also
project name from A25 to A26 😞
Best Regards,
Kamil
That makes it difficult. Tell the users not to add rows...