Excel VBA Macro

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)


Next X

[login to view URL] False

MsgBox ("Data has been imported")


[login to view URL] = True

Exit Sub


MsgBox [login to view URL]

Resume HandleExit

End Sub

Keahlian: Excel, Visual Basic, Visual Basic untuk Aplikasi, Pemrosesan Data, Entri Data

Lihat lebih lanjut: how to create a macro in excel 2010, excel macro tutorial pdf, excel macros, how to create a macro in excel 2007, using macros in excel, excel macros for dummies, excel vba programming for dummies, vba excel examples, excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, excel vba database connection odbc error, running excel vba macro sql server

Tentang Pemberi kerja:
( 7 ulasan ) Edmonton, Canada

ID Proyek: #25809311

41 freelancer menawar dengan rata-rata $30 untuk pekerjaan ini


Hello Sir, I can write you the macro codes. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ([login to view URL]). About Me - I am an Engineeri Lebih banyak

$55 USD dalam 1 hari
(787 Ulasan)

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 pr Lebih banyak

$30 USD dalam 1 hari
(962 Ulasan)

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. Lebih banyak

$60 USD dalam 1 hari
(272 Ulasan)

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 dalam 1 hari
(427 Ulasan)

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 Lebih banyak

$45 USD dalam 1 hari
(277 Ulasan)

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 Lebih banyak

$30 USD dalam 2 hari
(119 Ulasan)

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 expe Lebih banyak

$40 USD dalam 2 hari
(55 Ulasan)

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 Gen Lebih banyak

$39 USD dalam 1 hari
(120 Ulasan)

Hi. I am ready to write your project. I have written many automation Excel VBA macros. Will complete within 1 day

$10 USD dalam 1 hari
(47 Ulasan)

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 dalam 3 hari
(32 Ulasan)

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 dalam 1 hari
(20 Ulasan)

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 dalam 1 hari
(31 Ulasan)

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 Scrap Lebih banyak

$30 USD dalam 2 hari
(23 Ulasan)

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 Lebih banyak

$30 USD dalam 1 hari
(18 Ulasan)

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 dalam 1 hari
(33 Ulasan)

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 dalam 1 hari
(11 Ulasan)

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 dalam 3 hari
(6 Ulasan)

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 dat Lebih banyak

$35 USD dalam 2 hari
(6 Ulasan)

Hi I read your project carefully. Im an expert in EXCEL VBA, Macro, etc. I'm ready to start right now. I will make formula as per your requirement with good and professional quality without any error. Please contact w Lebih banyak

$50 USD dalam 1 hari
(11 Ulasan)

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 Lebih banyak

$30 USD dalam 2 hari
(4 Ulasan)