Recent Activities

Reached 1 year of membership at OzGrid

i see, okay i will make a new thread

Hello, I needed help with something im working on.

I have a set data of data that counted average data of several years.

There is a column of average that i hid to help with the calculation.

Below my data which is a bar chart is a total for annual average

…

The code I suggested in my previous post will fix the issue of the "\" on the end of the parent folder - if you don't add it to the parent folder in cell A1, the code will simply add it for you. This seems to work OK for all the test cases I've created…

in addition to post #6 - it seems like the problem now is for longer parent folder paths...the files do not even show up..the path length is "C:\Users\[username]\Downloads\duracell 4GB"

so basically, your saying that I just need to add a "\" to the parent path ?? Also, what if i want to get all subfolders within a parent directory but I want to exclude a deeper nested subfolder ? how can I adjust the code?

Reached 1 year of membership at OzGrid

The problem I think is not including the final backslash in the parent path, this should be fixed by adding this line in the ListMyFiles sub:
(Code, 2 lines)

best place is probably here:
(Code, 4 lines)

Sorry for late response, i created a temp column with values then used the find formula there to make it work. As the original column had formula instead of values. When its values in column then find works like charm.

Thank you for your inputs My Roy and…

Feel free to share your comments ...

Hello,

Have you tested
(Code, 7 lines)


Hope this will help

If t is not returning "Nine" then the the code will not find anything.

I think the problem is occurring with "asf() = Split(Replace(excludedSubfolders, ", ", ","), ",")"

I have created a similar thread, but left that one open to any suggestion as the solution.

In this thread, I would be keen to know if false statement can do nothing - for any future reference.

attached a sample worksheet

If I am not mistaken ...

You have just created a new thread with exactly the same question ...

By the way ... feel free to attach a sample worbook ...

I have a table with data for last quarter
Months Value
Oct-20 10
Nov-20 20
Dec-20 18

Another table with historic data that I want to grow:

Months Value
Jan-20 10
Feb-20 18
:
:
Oct-20 ---
Nov-20 ---
Dec-20 …

Hello and Welcome to the Forum

To make everything easier for everybody ... just attach a sample workbook

(Quote from Carim)

Now it works perfectly well. Thanks a lot!
Appreciate your help.
Dilshod

You are very welcome

Thanks a lot both for your Thanks ... AND for the Like