I was wondering if there was a method in Excel to fill in the next X number of rows in a blank column if the dataset is filtered. So for example, if I have the following filtered, fictitious data set:
Color Price Brand Manufacturer
Row 1 Red 2 DumFun
Row 2 Red 3 DumFun
Row 14 Green 2 DumFun
Row 17 Orange 5 DumFun
Row 23 Purple 4 DumFun
Row 59 Orange 3 DumFun
. . . .
. . . .
. . . .
. . . .
Row 984 Blue 5 DumFun
I have filtered the dataset for brand name, in this case "DumFun". What if I wanted to add "Taiwan" automatically for the first 130 rows, and then "Japan" for the next 150 applicable rows in my dataset, etc. without scrolling manually? Moreover, is there a way to ensure that these added values only appear in the next X rows for what's visible on my screen? For example, if I add "Taiwan" to just the first 4 rows, then I could have "Taiwan" in Rows 1, 2, 3, and 4. But 3 and 4 are filtered. In reality I just want to automate adding the values to Rows 1, 2, 14, and 17: what I see on my screen.