#1   Report Post  
Old June 7th 07, 05:29 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Oct 2006
Posts: 26
Default Get last in row

Good afternoon everyone,

I have a sheet that has 4 different workbooks (Sheet 1, Sheet 2, Sheet 3,
Sheet 4) that i need to get data from. The workbooks are the same templt for
each one.

Sheet 1 - Sheet 4
1 (merged cell ) 06/01/2007 (merged
cell) 06/02/2007
2 unit opened closed rtd ending opened closed
3 AM 123 45 68 79 101
65 48
4 BB 458 98 213 65 520
301 230
5 CC 99 52 32 55 50
32 10

I have 7 days on each sheet (because it will only fit about 7 days per sheet)

My goal is to say on another sheet "If unit is "AM" then go to and get the
last "RTD" that was entered from Sheet1, Sheet2, Sheet3 or Sheet 4"

Make sense? Hopefully I don't have to re-do my whole sheet... btw - I have no
idea on how to use VBA and Macros... (little more complication)

Thanks again everyone!!

Message posted via OfficeKB.com

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017