Forum Discussion
need help using header reference to pull data from worksheet
Hello everyone, thanks to those who take a moment to read this. I might be overthinking but I'm trying to setup a Master Inventory style sheet. Using date format as yyyymmdd or 20231125 if in...
Hi HansVogelaar ,
Thank you for the suggestion. The data sheets are very similar to the master sheet, same row heading and then values based on the inventory count.
I'm just wanting to pull the inventory count but use the column heading, maybe a vlookup would work better.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?