Find Jobs
Hire Freelancers

Excel VBA Macro

$10-30 USD

취소됨
게시됨 거의 4년 전

$10-30 USD

제출할때 지불됩니다
Hello all, I am hoping to write a macro(s) to assist me in Copying named ranges from another workbook and giving the copied values a new name. Source workbook: "WBSource" <-- where the named ranges are currently are Destination workbook: "WBDest" --- where the named ranges need to be pasted and re-named. (this workbook to hold the macro). Named ranges to be copy/pasted: all to be imported is on a "Table2" I would like to be able to: 1. I manually open "WBDest" 2. Run a macro "Macro" 3. Macro asks me for the path of "WBSource", and open it 4. [Begining of LOOP] Macro Loop through "Table2", Each cell "X" contains the name of a named range that needs to be transferred from WBSource. 5. [LOOP] Macro Copy the named range "X", and paste it to "TargetSheet" Column F Below the last used Row 6. [LOOP]Turn the copied cell into a named range and name it [login to view URL] & Cell F9 value. so if X is holding "FFCost" and Cell F9 value is "_3", I want the copied item to be called "FFCost_3" 7. [LOOP END] For Next X, until we looped through all cells of "Table2" <-- Table2 is a one-column table Below is the code I was able to come up with. As you can see I am missing the LOOP part. Thank you in advance Sub Import_Test2() On Error GoTo HandleError [login to view URL] = False Dim WBSourcePath As Variant Dim WBSource As Workbook Dim shDest As Worksheet Dim X As Range Set shDest = [login to view URL]("TargetSheet") WBSourcePath = [login to view URL](, , "Locate the WBSource") If WBSourcePath = False Then Exit Sub Set WBSource = [login to view URL](Filename:=WBSourcePath) For Each X In Range("Table2") [login to view URL]("f9").Value = Range(Xname) 'MISSING ALOT HERE' Next X [login to view URL] False MsgBox ("Data has been imported") HandleExit: [login to view URL] = True Exit Sub HandleError: MsgBox [login to view URL] Resume HandleExit End Sub
프로젝트 ID: 25809311

프로젝트 정보

36 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
36 freelancers are bidding on average $30 USD for this job
사용자 아바타
HI, I am good at Excel and VBA. I have referred the code Please share the source and destination files. I can transfer the named ranges as required. Looking forward to discussing further in the chat and work on the project. -Chandra
$30 USD 1일에
5.0 (972 건의 리뷰)
8.1
8.1
사용자 아바타
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro to automate your steps. I plan to use VBA code to accomplish this. The Excel file will run on PCs. I will charge you $60* and can deliver within a day (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having, I have completed nearly 400 projects successfully in 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$60 USD 1일에
4.9 (278 건의 리뷰)
7.7
7.7
사용자 아바타
Hi, how are you?, my name is Cristian and i am Excel/VBA expert. You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elqueabandona Contact me to discuss the details. Cheers
$45 USD 1일에
5.0 (291 건의 리뷰)
7.2
7.2
사용자 아바타
Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can complete this code for you. Kindly contact me. Roy
$35 USD 1일에
4.9 (439 건의 리뷰)
7.2
7.2
사용자 아바타
Hi, As I understand you need Excel VBA macro to copy from one workbook and create named ranges. It would help to discuss further on this . A sample file would really help. With my extensive experience on Excel VBA, I am keen to work on this project. Looking forward to hearing from you. Thanks
$30 USD 2일에
4.9 (126 건의 리뷰)
6.3
6.3
사용자 아바타
Dear Sir, I have read your project details carefully and understand it clearly. I can make Excel VBA Macro the advance formula by maintaining 100% accuracy of your data absolutely as you want. I am an Excel Formula Generation, VBA Macro Coding and Automation Process expert with 5* ratting. You don't have to pay upfront, we can work on milestone basis. I can start right now, please message me to discuss more. Regards, Anowar
$39 USD 1일에
5.0 (166 건의 리뷰)
5.9
5.9
사용자 아바타
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few projects which involved Programming, web scraping, excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$40 USD 2일에
4.9 (62 건의 리뷰)
5.9
5.9
사용자 아바타
Hi. I am ready to write your project. I have written many automation Excel VBA macros. Will complete within 1 day
$10 USD 1일에
4.9 (58 건의 리뷰)
5.4
5.4
사용자 아바타
Hello Sir, I am expert in Excel VBA Macro I can help you with it also I can start form now can we discuss ? I am waiting your response Thank you
$70 USD 3일에
4.8 (32 건의 리뷰)
5.6
5.6
사용자 아바타
Hi, I am a scholar from IIT Delhi and IIM Calcutta, 2 of the most prestigious Engineering and MBA colleges of India. I have gone through your requirements and have a few questions for you. I am excellent with Web Scraping and can do your project with 100% accuracy in 1-2 days. Please message me once before awarding this project so that we can discuss this further. Thank You, Antriksh
$30 USD 2일에
5.0 (40 건의 리뷰)
5.0
5.0
사용자 아바타
Hi there, I can help you in your macro creation. I am excel vba expert and have years of experience in creating automations, formulas, macros. please massage me to discuss more. Regards, Ravinder
$25 USD 1일에
4.9 (37 건의 리뷰)
4.8
4.8
사용자 아바타
Hi there, I can help you to fix your issue. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your message. Regards, Karthick G.
$30 USD 1일에
5.0 (27 건의 리뷰)
4.7
4.7
사용자 아바타
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with Excel and VBA. It will be quick and accurate. If interested, we can discuss this further on chat.
$30 USD 1일에
4.5 (19 건의 리뷰)
4.5
4.5
사용자 아바타
Hello, I can help you with the missing part of the code, please send me a message with the Ok and with the files as example, and I will start working on it immediately
$15 USD 1일에
5.0 (33 건의 리뷰)
4.2
4.2
사용자 아바타
Hi, I am super expert in excel automation via VBA, I am a computer programmer since 1998, please come on chat, i will solve it right away.
$30 USD 1일에
4.8 (11 건의 리뷰)
3.6
3.6
사용자 아바타
Hello. I'm a specialist in Excel and macros. I can perform all the tasks you need, or to repair any code you already have.
$30 USD 3일에
5.0 (6 건의 리뷰)
3.4
3.4
사용자 아바타
Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and data visualization using excel VBA,.... I promise you for a quality work at an effordable price on time. Expecting a reply soon. Thank you.
$35 USD 2일에
5.0 (6 건의 리뷰)
3.1
3.1
사용자 아바타
Hi, we have worked on several excel data and macro projects. We can gone through your description and we would be happy to help you with your work. We can add the loop for you as per your requirements. Kindly share the files so that we will get idea of what needs to be looked up and matched and data to be copied from source file and get the work done on priority. Hoping to hear from you. Thank you.
$30 USD 2일에
5.0 (7 건의 리뷰)
2.8
2.8
사용자 아바타
Hi, My historical achievements :-) [ as far as I know you are familiar with macros] I’m a Full-Time Fast Data Entry Operator Offline/Online. I have 5+ year’s experience and I have performed all the duties listed in your job description that I assure. My data entry skills and typing speed makes me a good fit for the Data Entry position. I can handle MS Word, Excel, PowerPoint, and PDF conversion. Let's initiate quick chat and discuss together................thanks
$15 USD 2일에
5.0 (9 건의 리뷰)
2.7
2.7
사용자 아바타
Dear Sir/ Madam I have good experience in Excel Macros. My recent projects was to create hierachical Chart in excel using macro. I can understand your requirement quickly and produce result very effective and efficient manner. Please initiate chat so that I can more details about your requirement
$30 USD 3일에
5.0 (5 건의 리뷰)
2.4
2.4

고객에 대한 정보

국기 (CANADA)
Edmonton, Canada
5.0
7
결제 수단 확인
4월 11, 2016부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.