full

<tbody> <tbody> product a b c d e bioprine <tbody> Rs 10 for 5 product </tbody> <tbody> rs 20 for 10 product </tbody> <tbody> rs 30 for 15 product </tbody> <tbody> no of product required </tbody> <tbody> rate </tbody> <tbody> customer will enter desired no of product...

I have an employee worksheet that I am using to get open enrollment processed. Our insurance provider provided us with a a sheet with employee names and their redacted social security number(ex xxx-xx-1234). I am needing to have the full SS number displayed. I have a another sheet that lists...

=IF(C4="","",IF(C3="parttime",0,LOOKUP(DATEDIF(C4,TODAY(),"m"),{0,3,96,180;0,10,15,20}))) I have this formula the second part works but they first part has changed If you are a part timer you only get 4 days vacation after a year there before they didn't get any c4 is the the start date if...

Hi! I need help building an expression for a field in a query I'm designing. I have columns of dates and types of reviews. Example: SiteID SiteDate Purpose 03500000 05/09/13 Initial Full Scope 03500000 08/17/15 Periodic Full Scope 03500001 05/09/13 Initial Full...

Hello, I'm using the code below to decode a list of hyperlinks in column A however, id doesn't grab the full URL. All of these links go to different bookmarks within the same website page. Example: The full URL is...

I have an Excel report which indicates times in hh:mm:ss but formatted as text, and I'm looking for a formula that can sum the full range of them and display total hours. TIMEVALUE seems to work for one cell but not the full range. Any thoughts? Thanks Baker

does anyone have a formula to help calculate UK redundancy pay rules are as follows: -0.5 weeks pay for each full year under 22 -1 week pay for each full year they were 22 or older but under 41 -1.5 week pay for each full year they were 41 or older -length of service capped at 20 years -weekly...

I need Excel help. I need to keep using the following code to load a CSV into an Array, Can somebody complete the code to make it work for me? THANKS! Sub Import_CSV() Dim CSV_File As String Dim iFileNum As Integer Dim CSV_Row_Line As String CSV_File = "C:\Sample.csv"...

Hi, I have a short name in one sheet and a full name name in another sheet. how do i bring the full name next to the column of short name. for example: short name "Fila" is in one sheet and full name "Fila Industrial Chemica SpA" is in another sheet. how do i bring "Fila Industrial Chemica...

hi.. i wanna know how can i have table and charts of a sheet Full screened and FITTED (in every size of monitors ) when i click on the button1 .. i have used this code but it didn't work properly ActiveSheet.UsedRange.Select ActiveSheet.ChartObjects.Select Application.DisplayFullScreen = True...

I recently asked about counting "occurrences" and "half-occurrences" in an absence calendar. The premise is that row 1 contains a value indicating an absence (UP = unplanned, T = Tardy, LE - Leave Early) If the absence is .25 of an hour up to 2 hours, it's half an occurrence, if it's 2 hours or...

Do anyone know how I can simplify this codes???? Private Sub CommandButton2_Click()'Declare the variables Dim AddData As Range, Current As Range Dim user As Variant, Code As Variant Dim PName As Variant, AName As Variant Dim ws As Worksheet, ws2 As Worksheet, ws3 As Worksheet Dim result As...

I am trying to run a userform in full screen on opening a workbook then place a plan view drawing of a site at full screen and on that drawing have "hot spots" ie command buttons that carry out an action. Thats the broad brush stroke of my requirement. My issue is maintaining the relationship...

Hi guys! So I got a 2003 Excel file with 25+ full (65536 rows) sheets of data, and I saved it as a 2010 file. Now I need to copy/paste all of that data into a "Master" sheet in the 2010 file. I want to create a macro to do this (because I have to do this for multiple files), and I've managed to...

Hello, So as part of a VBA project I'm working with in Excel, I am trying to simplify some SQL writing, but I can't get the Left Joins to work. Basically, I have many tables and I want to be able to pull information from all of them. They are set up in the following way. MASTER_TABLE...