Generic Macro for filling values in a table in Excel

Question

I know there must exist Excel Macros that can automatically fill in the values of empty cells in a table given the values in the header row and column as well as other configuration parameters in other cells. Of course, these macros will usually be tied to a particular set of attributes, ect. Does there exist any generic macro for this which can easily be adapted based on the situation?

• Note: I don't actually need such a Macro, I'm simply trying to see if one exists for the purpose of comparison.

Answer 1

Pretty vague. There are add-ins that exist that fill sample data automatically. I could Google it, but it's hard to tell by your question what you are looking for exactly.

Answer 2

So you're looking for a macro that sets a cell's value based on it's formatting if it finds the cell to be empty? I'm not sure that there's a sample out there that's going to be exactly what you're looking for, but it sounds like a simple enough thing to make that finding something to compare it with won't yield much different results.

"For each of the cells, replace the empty cell with a value based on the cell's formatting."

1) a 'For Each' loop referencing the cell range

2) an IF statement 'If cellRef.value = vbEmpty then cellRef.value = '

3) just use multiple IF statements or a SWITCH case to determine the proper value to be put in the cell

My logic isn't chronologically correct, but you get the idea.