Kapalı

Excel VBA Copy/Cut and Paste with Condition

I need someone knowledgeable and expert with Excel VBA

What I need is to cut/copy and paste a row of data from one sheet to another with a condition. Here's the details:

In Sheet "AR Format" if Column A have "x" value on that cell it should select the range (A2:L5) then paste it to Sheet "Connect"

Then, we'll go to Sheet "AP Format". If Column B have "x" value on that cell, it should select the Range (A2:L5) then paste it to Sheet "Connect" as well

Sheet "Connect" should have a result where the rows are now combined and it'll continue to alternately Copy/Cut then Paste from Sheet "AR Format" and Sheet "AP Format" to Sheet "Connect"

For you reference (see attached file) if you're up for it.

Beceriler: Excel, Visual Basic, Veri İşleme, Veri Girişi, Uygulamalar için Visual Basic

Daha fazlasını gör: cut paste vba excel, unlock excel password protected cut paste vba, vba excel cut paste excel cells, excel vba copy cell contents paste internet explorer, cells find cut paste columns vba excel, excel vba row cut paste, cut paste macro basics vba excel, vba excel cut paste macro, excel vba enable cut paste, excel macro vba functions cut paste, excel vba cell empty paste, excel vba open paint paste, excel vba 2010 pastespecial paste

İşveren Hakkında:
( 0 değerlendirme ) Marikina City, Philippines

Proje NO: #30223390

Bu iş için 20 freelancer ortalamada $20 teklif veriyor

(469 Değerlendirme)
7.3
(101 Değerlendirme)
5.7
(124 Değerlendirme)
6.0
abhinovpankaj

Hi, We have a team of enthusiastic and hard working [login to view URL] experience of varying from ~ 13 years to ~5 years in providing solutions for plugins,add-ons for all the Microsoft office products(Office , excel Daha Fazla

$35 USD in 2 gün içinde
(67 Değerlendirme)
5.7
ShivaniGoyalsai

Hi there, I have 10+ years of experience in VBA programming and database management system. As per the requirement I can build a tool that will do the task most efficiently. I am well versed in VBA and complete the p Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(23 Değerlendirme)
4.0
(17 Değerlendirme)
3.3
arunodaya123

HI, Hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects, I has done tons of projects similar to your requirement using VBA I can Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.5
roshansoni335707

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project. Your satisfaction with t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.1
freelancedo66

EXPERT IN EXCEL Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
PhantomXS

Hello, Thank you for considering my proposal. My name is Yash, and I have worked in Management Consulting and Valuations industry. I am currently pursuing my MBA in Canada. As part of my time at both Consulting, and Daha Fazla

$15 USD in 2 gün içinde
(0 Değerlendirme)
0.0
sayful51

Hello, Myself saiful Islam, I providing you for a best quality and a accurate result. Give me the task.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
junursal2

Dear Sir/Madam, I am an engineer by profession, but I love Excel, especially the logic & programming aspect of the application like data analysis, creating formulas, macros & Visual Basic for Applications (VBA) codes. Daha Fazla

$13 USD in 7 gün içinde
(0 Değerlendirme)
0.0
GKEvans

Hello, I can complete this for you in less than 3 days. I have 15 years of experience with Excel VBA.

$50 USD in 3 gün içinde
(0 Değerlendirme)
2.4
mikelamont

I just did something similar for a client. I would need to adjust the code to interact with your spreadsheet. Any desired conditional formatting is included in my fee. I will be on standby for the 3 weeks after the pro Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sansagar143

Hi, I am experienced vba excel developer. With experience of more than 6 years. I have created many tool for report automation, data mining and web scripting using Vba macro. I can help you to complete the requirement. Daha Fazla

$15 USD in 2 gün içinde
(0 Değerlendirme)
0.0
Fotero80

Hi, I send you the code. If you paste this into a macro, should do what you need. If this works, I just Ask You give my first star. Thanks. Sub Copy_Paste() SheetARFormat = "AR Format" SheetAPFormat = "AP Format" Shee Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
tomajas

I have an expierience in Excel VBA. .

$15 USD in 7 gün içinde
(0 Değerlendirme)
0.0
rajeev176

Hello Dear I have read your project and i have understood your project .I have the experience to do this type of project earlier . I have worked many platform [login to view URL] i have the confidence to do this If you want we Daha Fazla

$13 USD in 7 gün içinde
(0 Değerlendirme)
0.0
ganeshsharma4951

Under the general supervision of the assistant returning officer, the data entry clerk will be responsible for entering the names, address and phone numbers of voters into a computerized data management system to compl Daha Fazla

$10 USD in 7 gün içinde
(0 Değerlendirme)
0.0
jatramsingh60

I am an experienced Data Entry Operator and Data Processing Assistant and feel my skills will greatly benefit your jobs. I have also worked as a Email Handling, Excel Specialist and Web Designing expert throughout my c Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0