select and copy cells

**Richard Brook** · 11-11-2013, 10:13 AM

Afternoon all,
Have some slight issues (again)

I have trying to create a vba to start at cell F5, select all cells with values to the right(including F5), copy, move to sheet 2 paste and transpose in column F. Then select F6 and repeat the process paste underneath all previously copied values.

The first snag I have is if there is no data in the adjacent cell. So for example F5 has a value and F6 does not it copies the entire row. When I actually only want F5.

The second problem is to get the pasting to continue underneath previous values and not override them.
SO if f5,g6,h7 have values. The next paste needs to be 3 rows underneath the previous.

Hopefully that makes sense. If you are unsure please let me know.
Regards

**alansidman** · 11-11-2013, 10:15 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Richard Brook** · 11-11-2013, 10:18 AM

Please see attached for clarification

**AB33** · 11-11-2013, 10:26 AM

Result in sheet 3

Please Login or Register  to view this content.

select and copy cells

LinkBack

Thread Tools

Rate This Thread

Display

select and copy cells

Re: select and copy cells

Re: select and copy cells

Re: select and copy cells

Thread Information

Users Browsing this Thread

Similar Threads

VBA to copy and paste select cells

[SOLVED] Select only cells with specific content and copy with next cells to the right

[SOLVED] can only copy/select visible cells w autofilter on &hidden columns, want to copy all cells

Select and copy cells based on values in another cells

Select a range of cells and then copy them, and paste into other cells

Bookmarks

Bookmarks

Posting Permissions