Excel to copy different cells in a column divided by emty cells

Lene_B 0 Newbie Poster

8 Years Ago

I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck.

So in b column every time an empty cell shows it needs to go one down copy, and paste these data until the next empty cell is meet and redo as decribed. When in meets 3 empty cell the loop is finished.

Hope some of you are able to help. Thanks in advance :-)

1 Contributor
0 Replies
118 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.