Suljettu

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.

Taidot: Excel, Visual Basic, Tietojenkäsittely, Tiedonsyöttö, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Marikina City, Philippines

Projektin tunnus: #30223390

20 freelanceria on tarjonnut keskimäärin $20 tähän työhön

(469 arvostelua)
7.3
(101 arvostelua)
5.7
(124 arvostelua)
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 Lisää

$35 USD 2 päivässä
(67 arvostelua)
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 Lisää

$15 USD 1 päivässä
(23 arvostelua)
4.0
(17 arvostelua)
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 Lisää

$15 USD 1 päivässä
(5 arvostelua)
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 Lisää

$13 USD 1 päivässä
(2 arvostelua)
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 Lisää

$13 USD 1 päivässä
(0 arvostelua)
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 Lisää

$15 USD 2 päivässä
(0 arvostelua)
0.0
sayful51

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

$15 USD 1 päivässä
(0 arvostelua)
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. Lisää

$13 USD 7 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 Lisää

$20 USD 1 päivässä
(0 arvostelua)
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. Lisää

$15 USD 2 päivässä
(0 arvostelua)
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 Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
tomajas

I have an expierience in Excel VBA. .

$15 USD 7 päivässä
(0 arvostelua)
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 Lisää

$13 USD 7 päivässä
(0 arvostelua)
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 Lisää

$10 USD 7 päivässä
(0 arvostelua)
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 Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0