G
Guest
A B C D
1 [Worksheet / Tab name] Material Labor Overhead
2
I need to make a template which I can copy into differant workbooks. In the
above example I would like to input the worksheet (or tab) name into A1 and
have excel fill in the information for B, C, & D. The worksheet (tab) names
will always be different but the cells in the worksheets which contain the
data for B,C,D will always be the same. I could have as many as 50+
worksheets in the workbook. I know I may get errors in B,C,D if A is blank
but I can deal with that.
Question: What is the formula for cells B,C,D to:
1)look at the name in A
2)find that worksheet and
3)copy the date from that worksheet to cells B, C, D?
1 [Worksheet / Tab name] Material Labor Overhead
2
I need to make a template which I can copy into differant workbooks. In the
above example I would like to input the worksheet (or tab) name into A1 and
have excel fill in the information for B, C, & D. The worksheet (tab) names
will always be different but the cells in the worksheets which contain the
data for B,C,D will always be the same. I could have as many as 50+
worksheets in the workbook. I know I may get errors in B,C,D if A is blank
but I can deal with that.
Question: What is the formula for cells B,C,D to:
1)look at the name in A
2)find that worksheet and
3)copy the date from that worksheet to cells B, C, D?