Need to help with an excel formula/VBA script?

Question

I have an Excel sheet with information about auto parts. 

Part number is on A2. First Vehicle it fits is on B3. Second Vehicle it fits is on B4. Third vehicle it fits is on B5. And so on and so forth until the next Part Number for the next part. Some parts have hundreds of vehicles they fit. Some have 0 (parts for non-US cars). 

I need to have the part number on A3, A4, A5, etc.

rahimuddin · Answer

i do not recognize the VBA code to do it, yet you should use a conditional format to do it. choose the entire spreadsheet (or the determination of cells which will comprise your records, then click on Conditional Formatting, New Rule.. Use a formula.. and enter this: =A1=$A$a million %. your formatting, and also you're finished. This compares each cellular on your spreadsheet to the cost in A1. If it matches, it will be crammed with your formatted shade.

Blackened · Answer

You could do it with a macro (you'll want to save a backup copy of the original before running):

Sub FillDown ()

dim c as range
dim rng as range

set rng = Worksheets("SheetName").Range("A2:A1000" ) 'change to actual sheet and range
if c.value = "" then
c.value = c.offset(-1,0).value
end if
for each c in rng

next
end sub

Trending News

Need to help with an excel formula/VBA script?

2 Answers