Require a very simple code to do the following.
I have 2 workbooks. "[login to view URL]" and "[login to view URL]"
[login to view URL] has multiple rows with data across 30 columns like Name, Age, Height, Sex, etc etc. That data needs to be pasted to specific cells in template.xlsx.
For eg. Value of Name in row 1 to be pasted in D3, Value of Age to be pasted in F5,.and such predefined cell locations in template. I should be able to define which cell gets pasted where in the template sheet.
The sheet that contains this data ( name, age etc) also has Sr Nos. So this is what i require.
Macro will,
1. Make multiple copies of [login to view URL] and rename them as Sr No.xlsx. ([login to view URL], [login to view URL] and so on based on Sr no.)
In a batch it will be like
copy d:\test\[login to view URL] d:\test\[login to view URL]
copy d:\test\[login to view URL] d:\test\[login to view URL]
copy d:\test\[login to view URL] d:\test\3.xlsx.... and so on..
2. Open [login to view URL]
3. Copy data from first row of [login to view URL] and paste it to the [login to view URL] (all 30 cells)
4. Save the file, close the file.
5. Next
Hey There,
Thanks for posting the project. Its looks feasible and am Interested to do it.
Next steps:
Lets discuss/validate the complete requirement and I can start to get this done with required quality output.
I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality.
Lets discuss more online on chat.
Thanks,
Abhinav
Hi,
I am working as software professional in IT industry from last 3 years.
I work on VB scripting along with VBA for MS office applications mainly Excel
I have done these type of similar projects before.
You could check my profile.
Thanks
Abhinov
I have 6+ yrs of experience in excel VBA and have done 130+ projects in several freelancing sites.
Have done similar kind of work previously.
I can finish this task in 2hrs. Cost Estimate - 8$ x 2hrs = 16$.
Dear Sir,
I have already developed macro for such activities. Just need some modification. I can do the total work within 50 USD. Let me know your opinion.
Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 2 years experience to work in a any kind data process Web Scraping, Web Search, Excel, work would like to assure you that I will do my job according your expectation. I have a highly creative data entry studio. Close communication & ON-TIME delivery ensures a long-term relationship with our valued clients. We believe, goodwill in business is worthier than anything else. I give you drafts and unlimited revisions until your satisfaction. I do through research on every project to get the Best result as well as optimum client satisfaction. I can do your job in a best rate. Thanks
Hello dear Client,
Thanks you for your time to read my proposal.
We have vast experience in the Data Converting. We done this job very Easily and Provided you best result this is our promise to our client.
We provided the best result and meet deadline and make log term relation.
We are looking for awesome jobs that's not only fun, challenging, and enjoyable
My proposal includes the following benefit:
A. Computer Skills
-Microsoft Office
-Word Press
-Mail Chimp
-Google Analytic
-Google Drive
B. Accounting Skills
-Accounts Payable
-Accounts Receivable
-General Accounting
C. Administrative Skills
- 60 WPM Typing Speed
- Web Research
- Web Scarping / Data Mining
- Filing, Sorting and Organizing Data
- Virtual Assistant
- PDF Conversion
Its our aim to Provided the highly and highly customer satisfaction and Services.
Thanks
99 Unique Solution Valley
Hi,
I have previously worked on complex macros in my workplace related to formatting, formula, if-else conditions etc. I also very well understand the macro coding in Visual Basic. I am keen to work on below requirement to achieve the following:-
1> Simple yet effective macro to do below task
2> Saving of time for you
The plan of action (POA)
1> Gain more understanding of the requirement
2> Plan to write macro in visual basic
3> Testing of macro with some sample data
4> Hand over once the macro shows required results
Thanks a lot
Regards
Sweta Joshi
Hello sir/maam,
I bid on your project because I have the skills to do it. I'm a new freelancer here in this site, but I made a lot of projects like this outside this website. I am a fast learner and an honest worker. My main skill is Data Entry and Web Researching. I can do your project on time and submit it before or on deadline.
I can dedicate 15 hours a week for your project. I work for lower rates. And i'm also interested in long term projects with you. I will wait for your respond.
Regards,
Joshua Lorenz Dichosa