border

Hey guys, I'm having trouble with a particular macro. I want to copy the formulas in J4:S4 all the way down to the bottom of my table. The problem is there are already macros to insert rows based on specific criteria within the table. This is the reason I am copying the formulas down. So a...

Hi Team, Looking for some help to do the following... Data as follows: <tbody> Week Product Supply 1 Apple 0 2 Apple 0 3 Apple 0 4 Apple 5 5 Apple 0 6 Apple 0 7 Apple 10 8 Apple 0 9 Apple 10 10 Apple 0 11 Apple 0 12 Apple 0 13 Apple 0 14 Apple 0 15 Apple 5 16...

Hi Team, I'm looking for help with Power Query to achieve the following... Here's my data: <tbody> Product Type Sales Apple Bag 11 Apple Box 4 Pear Bag 7 Banana Bunch 8 Orange Bag 12 Orange Box 4 </tbody> I want to extract the records for each Product where the biggest Sales...

hi all.. how to make this use Custom Number Format : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; }...

Good morning I have a large data set approx 100,000 rows. I need to sum and combine the data based on Emp ID and DEPT only if they are the same. If the Emp ID and DEPT are not the same then leave it be. There will always be a Cur or Re in Column (S) The data must be Combined and summed in Cur...

hi all... how to fill/joint data based on header clue : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px...

I have a set of data that was given to me about 100000 rows like below. What I need to do is to count the areas but I can't figure it out. Any help would be appreciated! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...

Hi, hopefully I explain this well... I have data in cells A2:P2. This data goes down about 100 rows so far. I currently have all cells with a thin border. However when the value in column B changes, I want the entire bottom border to change to a thick outline. So it would look something like...

Hey Guys, I need a macro to fill color and border for used cells. In my sheet the used range will be start from row 2 and column C to I. Which means the color and border always will be in C to I column. The macro should not do any changes in 1st row. Thank you.

Hi Team, Looking for some DAX help again! Here's a mock up built in Excel to illustrate what I'm trying to achieve (data resides in range B2:K23): <tbody> Product Key Figure 18/12/2017 25/12/2017 01/01/2018 08/01/2018 15/01/2018 22/01/2018 29/01/2018 05/02/2018 Apple Demand 5 56 45 6 25 50...

I would like to know if it is possible to have marching ant around a comments border ? If so, how can I set this up

hi all... how to adding 0 and mark "-" without helper column... this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid...

hi all.... how to automatically sort and update asc to desc (alphabetic) this layout : <thead> data expected result </thead><tbody> zzz b zzz dddddd b dddddd dddddd dddddd dddddd dddddd dddddd s dddddd s s s s zzz s zzz </tbody> thanks m.susanto

Hi I have a border around a merged and centered cell group. The group takes a maximum of 18 characters but could contain as few as 3. When printed using say 3 chars, the border looks a little odd as it covers the entire area for the full set of 18 chars. Is there a way to expand or contract the...

hi all. how to counting number of number with automatically.... <tbody> data after formula 1 a 1 of 5 2 a 3 a 4 a 5 a 6 a 7 a 8 a 9 c 10 c 11 d 12 d 13 d 14 d 15 d 16 d 17 d 18 d 19 d 20 etc... 21 22 23 </tbody>...

Hello, I am naveed, this is the first time ever i am writing on a web portal for help. I hope this works out, below mentioned is my query. 1. Imagine below is the data that we have in Sheet 1 <style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style...

hi all... how to make this formula to calculate 2 conditions : this formula : <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col><col><col><col></colgroup><thead> C D E F G...

Picture Question does anyone know how to fix this? Even when I have selected no border, these editing lines still show up. Help!

(I figured this one would already exist, but when I do searches on the internet I get tons of results of people looking to change the color of border lines) I was wondering if anyone has a macro that could analyze the active range of a spreadsheet and apply a specific border configuration to...

Hello - I'm creating a workbook for our accounting team that starts with a QuickBooks report (sheet1), which feeds into a distribution report (sheet2) which feeds into a third report (sheet3) that will be used to import raw data back into QuickBooks. I'm having trouble syncing sheets 1 & 2 -...