Answer for:

I want to ask about a formula. Is any way to do?

Message 11 of 14

View entire thread
0 Votes

Grabbing the column headings is simple since you know exactly which cell they are in. Your headings will all be in the first row of Sheet1, so all you need to do is hit "=" then enter the cell containing the heading.

For example (assuming the same layout of columns as I posted earlier) to grab the heading "First Name" you'd use the formula "=Sheet1!B1". To grab the surname heading you'd use "=Sheet1!C1" etc.