Completed

Excel - Copy Ids from One sheet Multiple times to Another Sheet

I have an Excel workbook. One sheet has all the ids that I need copied into Sheet 2. Sheet 2 is a table of records. Each Id from Sheet 1 need to be copied 245 times to the table sheet. Then go to the next id and copy it 245 times to the next set of records in the table sheet. There is one blank row between each set of records. Each set of 245 records have the same id filled down 245 time in the id field, but each 245 set of records have a different id.

For example ids:

1

2

3

4

Sheet with the records

true, true, false, false, 1

true, true, false, false, 1

true, true, false, false, 1

true, true, false, false, 1

true, true, false, false, 2

true, true, false, false, 2

true, true, false, false, 2

true, true, false, false, 2

true, true, false, false, 3

true, true, false, false, 3

true, true, false, false, 3

true, true, false, false, 3

true, true, false, false, 4

true, true, false, false, 4

true, true, false, false, 4

true, true, false, false, 4

The ids are what I need to place in each set of records. The only thing separating the set of records is a blank row in the sheet named table.

Skills: Excel, Visual Basic

See more: excel copy sheet multiple sheets, sum multiple sheet excel, copy data website excel sheet, sum multiple sheet excel 2007, code export data sql multiple sheet excel 65000, import data excel multiple sheet vba, values multiple sheet excel, can copy website data excel sheet, excel automatic copy database sheet, transfer data excel multiple sheet access table

About the Employer:
( 24 reviews ) Pleasanton, United States

Project ID: #8113039

Awarded to:

vinitsinha1240

hello sir; I, Vinit Sinha, am willing to do your job. and i promise to provide you the perfect result within the deadline. please do consider my proposal. thank you:) sir i have a good review and reputation from More

$20 USD in 0 days
(18 Reviews)
3.6

23 freelancers are bidding on average $22 for this job

vsolcorp

Can we chat here? Please reply me when you will be available. We are really like to discuss with you regarding this project. We are open for any type of negotiation. Let's speak together. Thanks vSol CORP

$30 USD in 1 day
(94 Reviews)
6.5
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this and ready to start right now. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, More

$25 USD in 0 days
(76 Reviews)
5.8
talhamunir2002

can do in next one hr with 15$ can do in next one hr with 15$ can do in next one hr with 15$ can do in next one hr with 15$ can do in next one hr with 15$ can do in next one hr with 15$ can do in next one hr with More

$15 USD in 0 days
(123 Reviews)
5.6
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA macro :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You SIncerely Pra More

$15 USD in 0 days
(79 Reviews)
5.2
arman0464

!!Hello Sir/Madam, I Arman Khan PHD in computer science from JPR Rajasthan, India. I have 6+Years experience in this field with 99% of success ratio. Delivering top-level services is my specialty .I believe that my More

$25 USD in 1 day
(39 Reviews)
4.6
sadif18

Sir, I am willing to do your project and ready to start work. I will provide you a good result with accuracy . My aim is to satisfy my client by my work . Please response . Thanks

$21 USD in 0 days
(54 Reviews)
4.4
coolomar1998

Feel free to contact me. Budget is not any issue as well.I have team for quick and quality results. We can manage each and everything via private messages. Take a look on my 5 start feedback work.

$25 USD in 1 day
(6 Reviews)
3.7
RSUKANTA2014

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. I h More

$10 USD in 1 day
(10 Reviews)
3.4
surekash7096

I have the expertise in Excel with scripting and can do the task that you have described with ease and accuracy. Ready to start work immediately and complete the task for you

$25 USD in 1 day
(4 Reviews)
2.5
ikramhossien

Dear Sir/Ma'am, I'm a professional data-entry worker .I've read your work description clearly and I'm clear about your requirements for this job. i always try to do good task,because i give good work than you give More

$13 USD in 1 day
(7 Reviews)
1.3
Nosek

Hello, I am going to work now, so i will be able to do it in about 14 hours from now. If you really need it i will try do it faster (in 3 hour maybe) in my job. Cheers! PS. Pick me, i will do it fast and cheap More

$10 USD in 0 days
(2 Reviews)
0.3
vw1508028vw

A proposal has not yet been provided

$30 USD in 2 days
(0 Reviews)
0.0
indunilmyway

A proposal has not yet been provided

$15 USD in 2 days
(0 Reviews)
0.0
archana19k

Will complete the work on or before time with 100% satisfaction. Worked in a Multinational Company as a full time employee, now looking to work in part time. Also worked on same type of project earlier too.

$25 USD in 1 day
(0 Reviews)
0.0
parasuramankpr

I will complete this project with in required timeline without any issues / with good accuracy to ensure the employer satisfied with my work.

$25 USD in 1 day
(0 Reviews)
0.0
hamadaelmisy

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
andiaz0204

I am the best candidate for this project because I am well trained in using the excel. I have my own desktop computer and manage my own time. I hope you could consider my application

$25 USD in 1 day
(0 Reviews)
0.0
zhy

Hi there. I have experience in Excel thing. I can do it right now and can give the best result for you. Thank you.

$25 USD in 1 day
(0 Reviews)
0.0
miamalaluan

I can start now and finish the project on time . I always follow the instructions and easily understand what is told to me

$30 USD in 1 day
(0 Reviews)
0.0
nucleussoft2

Dear Sir, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requir More

$25 USD in 1 day
(0 Reviews)
0.0