jeffdolton
Board Regular
- Joined
- Dec 21, 2020
- Messages
- 100
- Office Version
- 2010
- Platform
- Windows
Hi, I'm looking for some code please.
I have a workbook that consists of a food and drink table downloaded from an EPOS system. Here is a OneDrive link to my file Test file Produc Library.xlsx.
I want to be able to fill in the gaps in column A by copying a last cell in the list to all the blank cells immediately below then move to the next item and copy that down and so on. So to be clear cell A12 to be copied to cell A41, then cell A42 to be copied to A56 etc. Please note that the length of this table isn't finite and there could be blanks to fill in below the last 'name' entry. That would depend if there are any options in columns B,C and D.
Thanks for your help.
I have a workbook that consists of a food and drink table downloaded from an EPOS system. Here is a OneDrive link to my file Test file Produc Library.xlsx.
I want to be able to fill in the gaps in column A by copying a last cell in the list to all the blank cells immediately below then move to the next item and copy that down and so on. So to be clear cell A12 to be copied to cell A41, then cell A42 to be copied to A56 etc. Please note that the length of this table isn't finite and there could be blanks to fill in below the last 'name' entry. That would depend if there are any options in columns B,C and D.
Thanks for your help.