draw

I not sure if it possible? VBA draw table line border every 18 count from col T to AF <tbody> COL T COL U COL V COL W COL X COL Y COL Z COL AA COL AB COL AC COL AD COL AE COL AF ROW1 A B C D E F F G H A D D G ROW2 1 2 3 4 5 6 7 ROW3 12 10 19 ROW4 1 2 3 7...

Hi All, I am wondering if I can enlist this forum's help. Can someone help me create a dynamic loan draw formula (highlighted row 10 in HTML table below) with the following constraints: - The loan cannot be overdrawn (i.e. cannot draw more from the loan than what is available in any given...

Hi All, I am wondering if I can enlist this forum's help. Can someone help me create a dynamic loan draw formula (highlighted row 10 in HTML table below) with the following constraints: - The loan cannot be overdrawn (i.e. cannot draw more from the loan than what is available). The ending...

If column A are names, and Column B are expiry dates for their cards, is it possible that I open a new spreadsheet, and draw only the expired name & date on the sheet? I have multiple of cards that required to draw expiry date to another sheet, will the formula be similar? Thanks for your help.

Hi, I am trying to draw a polyline using x,y,z coordinates. I found few threads that is similar to what i am looking for. But i was never successful. Is there anyone who can tell me how to draw a polyline in 3 dimensions using x, y, z coordinates? Thanks in advance

I have a column like this: Line1: J1 Line2: J1 Line3: J2 Line4: J2 Line5: J2 Line6: J3 Line7: J3 Line8: J4 Line9: J4 Line10: J4 Line11: J5 Line12: J5 I would like a macro to find the last occurence of each J and draw a horizontal line in my table. In the above example, a line...

I'm preparing a schedule of people who are going to be receiving commission advances (draws). They are eligible to receive the draw the following month of their employee (we pay commissions one months in arrears so if they start in April their first draw would be paid in May). In one column I...

Hello, I noticed that when I'm using "Freeze Pane", my Draw tool becomes greyed out. Is there a workaround? Thanks! Anita

identify the 3 letter pattern in the draw line http://www.mediafire.com/file/27frtcym6d6ulxx/detectar_os_padroes_das_3_letras_no_sorteio.xlsx/file

Hi All, I have an Excel file that I will use as a form which needs to be signed, preferably using the "draw" feature in Excel. I see that in a new Excel workbook with the worksheets unlocked, the Draw tab items are active. However, in the file I am working, the sheets are protected and when the...

Hi Team Im trying to do something fairly simple but failing :) Lets say i have 10 rows each row has a value 1 2 10 20 24 56 and so on. In one column i have a Cumulative count 1 3 13 33 and so on. Based on the cumulative count i want to be able to draw a line under a row If (...

Hi, I have been trying to set a grid of 50 cells x 50 cells and use the Shapes.Addline method to draw lines on it using coordinates that relate to that grid. I think I understand the coding but am not clear how Excel decides where to draw the line on my screen. For example if I use...

I have a NAMES DRAW from a HAT worksheet. Names as selected from a list using RND. These names tick over in a cell. I had hoped to progressively increase the speed of the draw to the final winner - like a ham wheel. I am using a WAIT macros Application.Wait (Now + 0.000006) This is used in...

Will post again

Hi, I have 39 numbers that are divided into 6 groups of 7 numbers, ( Group 6 only have 4 numbers ). Group 1 = 1,2,3,4,5,6,7. Group 2 = 8,9,10,11,12,13,14. Group 3 = 15,16,17,18,19,20,21. Group 4 = 22,23,24,25,26,27,28. Group 5 = 29,30,31,32,33,34,35 Group 6 = 36,37,38,39. I'm not...

Hi, Can you use multiple IF function formulas in one cell to return a specific value? Im looking for a formula that will return a value of 'Win, Draw, Lost' from a result. <colgroup><col span="4"></colgroup><tbody> Friendly 2 TEAM NAMES Team Scores Navy U9 3 Yellow U9 2 </tbody>...

Hi I want to know based on what excel draw the trendline? Does excel take the average of values and draw the Trendlne? I have a chart look like "V" letter but upside down. When I right click --> trendline, excel will draw a line in the middle. It seems to me excel took the average values and...

Convert from the table of 9 sums to the line of each lottery draw http://www.mediafire.com/file/pcwdkvbbe6yqst7/pasta_sum_1a_9.xlsx

I'm I only really know basic excel but I'm trying to set up a spreadsheet to record football teams and results as games occur Arsenal win Man u draw Chelsea lose Arsenal lose Chelsea draw I then want on another sheet to record all this information by team i.e (based on the data above) to...

Here is the image with Brief Description if E3 value =1 Format need to draw with pocket1 as shown in picture if E3 value =2 Format need to draw with pocket1 and Pocket 2 should be visible https://drive.google.com/open?id=1IRsWrgdi0kD6fbu6W3PRCrRdY95ihaUw