tab reference

Given a table in tab named Main: __A__B__C 1 car1 15 30 2 car2 18 28 Then 2 tabs: car1 car2 Based on values from specific cells in tab car1 I color 15 e.g. (B1) yellow and (C1) 30 in red. So far so good. The conditional formatting setup for each cell horisontally...

Hi there, I have a spreadsheet that contains month tabs and each month I add a new tab. Trouble is, I have some columns in the spreadsheet that contain formulas for "prior month balance". If I do a Vlookup, I have to change the formula each time I create a new month's tab since I have to change...

Hi, I'm trying to make a contact list sheet for keeping track of which companies my coworkers have contacted for sponsorship. Each have their own tab to keep an updated list of who they've contacted, that makes it easy to see if anyone else has already contacted them. We would like it to have...

Does anyone know the way to reference the farthest right tab in a workbook? The formula would be on a summary tab, location of summary is the far left in the workbook, and essentially be a =vlookup(ref,"furthest right tab"&A:B,2,0) Thank you for your help Rob

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...