Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup from another sheet
Hi,
I have my business accounts on Excel. I have a worksheet called Hours with 5 column headers; Week Ending (formatted as date), Invoice (formatted general), Hours (formatted custom 00), Rate (formatted currency), Total (formatted currency) I have another worksheet called Invoice and I would like to be able to display the contents of the last cell in each column from the Hours worksheet so I can automatically derive the data on the Invoice sheet from the hours sheet. Each week I add another line on the Hours sheet and the contents will be different in each cell again. How do I do this please ? Thanks Jane xxx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |