| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy last cell with data in column E on one sheet to cell on anoth
From a cell on my "Summary" worksheet, I need to find the last cell that has
data in it in Column E on the "Account" worksheet and copy the data from that cell to the cell on my Summary worksheet. There are actually 10 or more "Account" sheets (each separately named) so I really don't want to do this manually. I've tried several suggestions from similar threads, using both the LOOKUP and IF functions but nothing has worked. Any help will be much appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you hide the value of a cell until data is keyed into anoth | Excel Discussion (Misc queries) | |||
| copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| how to make one column copy from one sheet to anoth column w/o zer | Excel Discussion (Misc queries) | |||
| copy every 30th cell in the column into consecutive cells in anoth | Excel Worksheet Functions | |||
Threaded Mode
