Excel Formula Needed

Ολοκληρωμένο Αναρτήθηκε Πριν 2 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

I need to build an excel formula that links to files in another folder. The issue I'm having is that when I update the link daily and go from one folder to another, the files have similar names but don't match exactly. The files always start with the same 3-4 letters which is why I think this may work. Example of what happens when I update the links is below:

Folder is updated from 5/10 to 5/11

excel files in the folder update as well. If the name of each file stayed the same from 5/10 to 5/11 there would be no issue. However the file names change from "BAR-0561651" to "BAR2165165"

Is there any way to make a formula that just pulls data in the link based on the first 3 letters of the file?

Excel Επεξεργασία Δεδομένων Visual Basic Εισαγωγή Δεδομένων

Ταυτότητα Εργασίας: #30175918

Σχετικά με την εργασία

22 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 2 χρόνια

Ανατέθηκε στον:

(784 Αξιολογήσεις)
8.4

22 freelancers κάνουν προσφορές κατά μέσο όρο $34 για αυτή τη δουλειά

daniyal3214

Hello, I just read your project description and will be glad to assist you with that on top priority basis. I am an experienced Data Analyst and advance level Excel user. Data Analytics, Automation and Data Visualizati Περισσότερα

$30 USD σε 1 μέρα
(220 Αξιολογήσεις)
7.2
AccountantArman

Sir, I can fix this issue in minutes. I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. "I have completed similar projects with fiv Περισσότερα

$20 USD σε 1 μέρα
(252 Αξιολογήσεις)
7.1
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA an Περισσότερα

$20 USD σε 1 μέρα
(21 Αξιολογήσεις)
4.8
AnuradhaVM

Hi, Greetings! ✅checked your project details. I can build an excel formula that links to files in another folder. https://www.freelancer.com/u/AnuradhaVM I Have 4 years of experience with Data entry, Data analysis, and Περισσότερα

$20 USD σε 1 μέρα
(41 Αξιολογήσεις)
4.8
ShivaniGoyalsai

Hi I have 10+ years of experience in VBA programming and database management. I worked several similar task and I can complete it most efficiently. if interested, we can connect and get stared. Thanks Shivani .

$20 USD σε 1 μέρα
(38 Αξιολογήσεις)
4.5
ACCASpogmai

Sir, I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. "I have completed similar projects with five stars from client". I can ha Περισσότερα

$20 USD σε 1 μέρα
(24 Αξιολογήσεις)
3.9
Sunitav36

Hi Sir, i have Checked the Project: Excel Formula Needed I carefully read your project description & I can handle this in my best care and professional manner. Please message me to discuss the work. Thankyou, Sunita

$20 USD σε 1 μέρα
(23 Αξιολογήσεις)
3.8
pawangaire123

Greetings! I’m very much interested to your requirements and Job openings. I am a Professional in Microsoft office, Data Entry, PDF, and excel with over 5 years of experience, therefore, I can easily do this job. You c Περισσότερα

$10 USD σε 2 μέρες
(4 Αξιολογήσεις)
1.7
rhajar211

Hi, I'm the right person for your project. Experience in data entry for more than 5 years. I have been playing with Microsoft Excel for more than 7 years and I understand every inch of this software. As I concern that Περισσότερα

$24 USD σε 7 μέρες
(1 Κριτική)
0.4
dhruvilroyal

Hello dear sir.... I have seen your project and i want to work on this project I will do your job for sure . You just look at my work once, I will give you all the work perfect and I also have experience. I will do you Περισσότερα

$15 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
atulghodake25

Hello dear sir.... I have seen your project and i want to work on this project I will do your job for sure . You just look at my work once, I will give you all the work perfect and I also have experience. I will do you Περισσότερα

$20 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
Pechkindev

Dear Sir, Thanks for your posting project. I read your details carefully, so I understand what you want. I am python expert. I can make a excel update program according your requirement. It's very easy for me. Let's di Περισσότερα

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
3.5
YuvrajSingh0920

I can save your time and your money. Looking forward to work for you so that I can show my skills & creativity to you. I will make sure to fulfill all your requirements. I will do the work will full focus and dedicatio Περισσότερα

$20 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
somskm

Hi sir I am a data analyst with 8 years experience i can get your job done simply using a vba code where formula can be calculated , looking for an opportunity work with you Thank you Regard's somaiah

$20 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
sahoocarriers

I am working good. Belive me and give me your job. I will fulfill your requirement as soon as possible time. I need a chance for it.

$25 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0