Forum Discussion
Creating a function that will automatically fill the cells in an entire row.
I am trying to save time imputing data by setting up a system that will automatically fill out an entire row of data based on a serial number typed into the first cell in that row. I am imputing ing...
j_rags_30 You need to create a lookup table first and then you may use FILTER and/or XLOOKUP (since you tagged Office365) to fill the cell in A2 and down based on what's in A1.
Exactly how depends on the structure of the worksheet and data.
Can you upload or share (via OneDrive) a link to a file that demonstrates what you are working on?
