Hello people,
i have a request,
is it possible to copie a colum A and past this to colum B and skip the filled cells in colum B in the range B1:B50.
i have submit a sample with a trying.
greetings Jan
Hello people,
i have a request,
is it possible to copie a colum A and past this to colum B and skip the filled cells in colum B in the range B1:B50.
i have submit a sample with a trying.
greetings Jan
Try this:
DomPlease Login or Register to view this content.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi,
Not with a direct copy and paste, or even copy and paste with column B filtered for blanks.
You could however use a helper column and in say C2 enter:
=IF(B2<>"",B2,A2)
and copy this down your range, finally copying the whole of column C and pasting it back to column B as values.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hello, i have a next request. How get i that the Colom A1:A50 copie and past and skip the filled cells to example F1:F50.
greetings Jan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks