need to cut paste info from one column to another

[odieses]

What I am trying to do is have column B. Have a set range of lets say B1:B13. In that set range there are open slots to fill in data. The data I want cut and pasted from column range c1:c60. I want it to be pasted to lets say B4 the first open spot with no data. I dont want it to overide the current data in range b1:b3.

After the macro does the first cut paste I want a loop to come in and cut paste the next value from column c into the available open slot in the range b1:b13. Until the entire range is filled with data which in this case is names


So the order would be

Cut paste value c1 into open slot b4
Loop
Cut paste value c2 into open slot b7
Loop
Cut paste value c3 into open slot b13

Range b1:13 full stop Sub

Im running excel 2003.

If you guys can help with this request I would be extremely happy (im still a novice when it comes to writing excel macros)

[JOHN H. DAVIS]

If I understand you correctly maybe:

Please Login or Register  to view this content.

[odieses]

Awesome ill try it, and see if its what im looking for thanks for the help.

Ill give a reply for the result in a few min.

[odieses]

Getting object required run time error

[JOHN H. DAVIS]

Can you post a sample?

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[odieses]

Here is couple pictures. Its a work comp with no access to internet

[odieses]

Thanks for the macro I got working. I made an error copying it. It works for what I need it. Thanks again for the help I appreciate it.

[JOHN H. DAVIS]

You're welcome, glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[odieses]

Marked it solved.

Thanks again