Extract Data from specific cells in Multiple Files #3

data has to be copied to File called Textiles (1).
data is in other files which have the same name as the Name column. Sample file called RSWM is attached. Rows 17,83,93 is to be taken from these files.

If this works as you want, better delete apostrophe to convert formula to value, because so many linked formula to outer files are not recommended.

Please Login or Register  to view this content.

1. The code for "EVSALES" sheet is not working. Output is 0 and it shows the real output when I open all the other files.
2. The Name columns are highlighting the cells with green color ?

You should be able to see the formula in cell.
If the formula is correct, it is empty or 0 in source workbook.

Colored green when the row is updated for this time.

The formula is correct. The output is correct too. But the output shows up only when I open the respective file. Kid you not. Not sure why its happening only in EVSALES sheet and not the other one.
Is there a solution or should we try a different formula like in the other sheet ?

I can't replicate such issue.

Everything is doing as I wrote.

One possibility is, as I mentioned #4 and your previous thread, no good to keep many formulae with outer link.

I removed the apostrophe and the values in EVSALES are 0.
The workaround is to manually calculate this.
The formula would be
{[(B90 multiplied by B93)+B59-B69] Divided by B17}

Where did that formula come from?

And is it working now?

To my surprise, Yes.
Any clue why this works and the other doesnt?

No idea as I have no problem with my code as it is.

Could it be that I am facing this issue because of the location of the folder ? My folder is in the Desktop.

I wrote the code based on all workbooks, including textiles (1), are in the same folder.

But working in some sheet and no in some is not possible.

No No. All files are in 1 folder.
https://file.io/2LPqkeHcx8Gf this is the whole folder. Can you try and run your code in it ? Please replace the code (to your code) in the mainfile since it has the updated code now.

All files have freeze pane and Col.B is not visible.
Remove all freeze pane from all files or let all columns visible.

I added freeze pane later.... after I "fixed" the formula.

Do as you like.
That was a reson, so good luck.

OK, then upload some files without freeze pane and master workbook that doesn't work.

ok check this. https://file.io/PEAHZ0OsdILk

They all have freeze pane!!!

oh the other files !!!!!!!! lol I thought you meant the main file. Cant help it with the other files... those files are exported as they look from a website.. Is there a macro to remove freeze pane from all those files in one go?

This will open all the files in the folder and if the file has "Data sheet", it will remove FP and close.
And you will find the time for open/close files.
If it is not freeze paned, it will finish in just a second.

Please Login or Register  to view this content.

It works now lol. Why didnt we think of this earlier ? This FP issue arose in an earlier thread too. Anyway, thank you.