Hi Riny,
Back again with some queries on validation formula not Spilling over rest of rows and columns as below snip. Highlighting columns Region, Project Coordinator, Project Officer (s) and bringing formulas down (ctrl+shif+arrow down) isn't working. Is formatting those rows/columns the issue?
Thanks Riny,
Dan
Not sure what you mean. Ctrl-Shift-Arrow down just selects cells from the active cell up to and including the first non blank cell. It doesn't copy anything.
Or are you referring to the N/A errors? If that's coming from an XLOOKUP formula, we discussed before, Excel simply doesn't find a match. Need to see the file to resolve the issue.
Hi Riny,
I got the data validation correct under Regions column and partly filled up data (Regional Coordinator and Project Officer) when a specific region is chosen but it stops filling at a certain row down the sheet and can't figure out why.
The Regional Coordinator and Project Officer are under same workbook but separate worksheets.
I copied the formula down from the active cell by just dragging the cross-hair down but is there a better way to do it meaning copy a formula down?
I misunderstood that Ctrl+shift+arrow down as copying but is just highlighting ranges. I got that now. Thanks.
Do you need the spreadsheet itself?
Thanks
Dan
Yes please, upload the file. Just remove anything confidential.
