fill blanks

I need a formula that if a cell is empty then it will used info from another cell, but then if I add text to that cell it will show that info util it is deleted and is blank again so it would revert back to the formula. <tbody> A B 1 table 50 2 chairs 300 3 none 0 4 if blank then use...

Excel 2016. Windows 10 I have an Excel macro that exports data into a file so that we can run a process on it. However the process we run the data against requires this exported file BE AT LEAST 101 rows of data for the process to work. So I need help modifying this macro to automatically fill...

Hi Everyone I have a sheet contain some product numbers (No duplicate) with blank 9 values needed to be filled as screenshot. Another sheet is the values of each product number but its contain more than 1 value as screen shot. The question is "Can I use VLOOKUP or other function to fill...

On this one, I am working with data in columns A-F, G is not currently used however, H - AZ are occupied with important info. Referring only to the data in columns A-F, with a few thousand lines of names and addresses etc, several of the cells contain nothing and are blank. I need a quick...