VBA script that will allow me to copy the unit # in column C to the empty cells below until it reaches the next unit #, then copies that unit #

[ffarah]

I would like to create a VBA script that will allow me to copy the unit # in column C to the empty cells below until it reaches the next unit #, then copies that unit # to the empty cells below it until it reaches the next unit# and so on.

I have attached a sample excel spreadsheet.

Really appreciate any help.

Thanks

 

[Marc L]

copy the unit # in column A

So a smart worksheet must have 'Unit' header is cell A1 …​

​

 

[ffarah]

the original has all the proper headings. You dont need that for the solution Im hoping for

 

[Marc L]

As you misread / misunderstood my previous post so I will not waste my time,​

it's what happens when the attachment does not match the description …​

​

 

[ffarah]

Thanks Mark, makes sense. was hoping for help with solutions.

 

[Marc L]

Then attach a workbook well matching your description or correct the description according to your original attachment.​

Proceeding like you did in your initial post means​

you are enough confident with your Excel / VBA skills to fit to your real workbook any code any helper may share …​

​

 

[ffarah]

I have changed the column Letters in my post to agree with the attachment. When I copied and pasted from the actual file I placed in a different column..
Ive been trying, amongst other solutions , to use the End(xlDown) then offset to move up one row when creating my range, but have had no luck

 

[Marc L]

Wild cross posting and already solved in another Excel forum ‼​

​

 

[ffarah]

Wild cross posting and already solved in another Excel forum ‼​

​

yes. Lots of smart people in those forums. All their scripts worked perfectly.

 

[Marc L]

Like the one I removed from post #8 which was more efficient & shorter …​

​

 

[vletm]

ffarah​

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

excelguru.ca

As You have read from every Forum:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.