Formula to copy the headings to the Description column b when i make - Microsoft Community

date	description	total	cost of sales	carriage	post	wages	phones/int	rtes	rent	repairs
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
totals		0	0	0	0	0	0	0	0	0

moved from: office / excel / windows 8 / office 2013

for example logic follows:

so entry in line 2 in column headed wages if g2 =50 formula pick header "wages" , drop cell b2. there 1 entry in array per line.

thanks allyn

Office / Excel / Microsoft Office Programming / Office 2013