A B c D
4/5(date) 4/6 (Date) =B2-A2 I wanted to get in D2= State Tax:-[4/5] through formula when i put d2= If(C2>1,"State Tax:-"&TEXT(A2,"mm/dd"),"") i get State Tax:-4/5 but i wanted to get State Tax:[4/5] how do i do this cell A2 and B2 are...
Is it possible to link two or more different excel file together and when you add a spin or scroll button to sheets it will scroll through all the file back and forth.
Here is my sheet where i have user form when i put Room # 101 in the user form text box 1
all the data will fill the row correspondence Like below
Room # Guest Name Rate Ldg Paid Ldg Code
101 Sunny $55 $59.99 2
102
103
104
105
106
107...
Is it possible to convert lotus 123 file (Macro) in to excel 2010. If does convert how? Here is the file
https://docs.google.com/file/d/0B2kKysKalbcNU25ic1JZSEFPc0k/edit
Is it possible from user from text box filed will display at two different work sheet in different order.Suppose I have a user form with text filed name when i put any name when i click submit it will display the result in sheet1 in raw 1 column1 and also sheet2 raw 2 column 3 something like...
I have reservation templets in excel with two sheets sheet 1=Room Reservation Sheet2=Avilability
Room Reservation
A B c d e f g h i i j k
Booking No Guest Name PH Country Date in Date Out roomType room#...