style

is there a way to make more than one preset printing style for one worksheet? ex: style 1 = print 'landscape' style 2 = print 'portrait' (that is - to arrange the styles, save the presets...then just select which style to print - without re-arranging them again each time) many thanks

i have a workbook with 4 sheets 1st three are Jan, Feb, Mar and 4th one is home. Columns are style no., qty and unit price. i want to check index match the unit price of mentioned style number from all three sheets. Like i want a formula in HOME sheet in cell C2 which see style no. in cell A2...

Hi all, newbie here, don't know what else to use besides IF function for this. Reaching nesting limit doing it this way. Any alternative ideas are appreciated! Formula in B5 of image attached: =IF((AND(C2=1.5,D2="L",H2=0.625)),'[1-MASTER.xls]A & LH SINGLE ROD END'!$M$10, (isolating this on...

Hello, 1. I have a multisheet excel file where I would like VBA code to go out onto the server and pull in jpeg images based on style names listed in the spreadsheet. 2. Style names could be on any cell say from range a1:ab200. Generally about 60 styles per excel workbook tab. We use multiple...

Hello, I'm using VBA to add a table to a sheet but when I do so, it doesn't clear any existing formatting when applying my style. If you add the table manually, you can right click on the style and select 'Apply and Clear Formatting'. I've tried using the recorder to see what I get but it only...

Good day, I'm trying to match the value of 2 cells from one sheet to 2 column in another sheet. I can get to work with only one data but not both. The main point is to be able to look up previously entered information and avoid duplicate. here is the code i'm using to find duplicate. Set...

Hi, I'm trying to figure out a formula for data validation to restrict entries in a cell to a certain format... it can be a text string, doesn't have to be a date value or anything, but the format has to be: YYYY-ABC123-123 where yyyy is a four digit year the dash is present abc are any...

I have tried the following code to apply Table Style within the same Workbook, and it works fine: ActiveSheet.ListObjects(ActiveCell.ListObject.Name).TableStyle = "Table Style 1" However, when I am trying to apply the same style to a table in a different Workbook, it's not working. This is the...

Below is an example of the data that I'm trying to analyse and I need 2 formulas to look up a style code and find the week when it was first stocked (i.e. the inventory column first showed a value for that code) and the week it went out of stock (i.e. the inventory was 0). A couple points to...

I have a sheet of data which has dates in the US style, i.e. mm/dd/yyyy. How would I go about re-formatting them into the UK style, i.e. dd/mm/yyy? <tbody> US Date UK Date 2/28/2018 28/02/2018 3/01/2018 01/03/2018 3/30/2018 30/03/2018 3/31/2018 31/03/2018 4/01/2018 01/04/2018...

The next 3 lines of code works fine. However, the code at bottom returns "error 2015" or Type mismatch 13 at runtime. Working_FormulaR1C1 = "=MATCH(R23C1,IF((Sheet1!R5C2:R100C2=R23C1),Sheet1!R5C2:R100C2),0)" Testing = Application.ConvertFormula(Working_FormulaR1C1 , xlR1C1, xlA1, xlAbsolute...

I'm hoping someone can help. I copied and pasted a long list of hyperlinks to a new spreadsheet in Excel 2016 in my Windows 2010 OS. The hyperlinks are now a mix of colors. Some are the standard "Hyperlink blue" and others are black. I found the following on the Microsoft Office Support site...

Hello, I'm trying to automatically convert number formatting to match the style in some European countries by swapping the comma and period position from the USA style of, "123,456.78" to read like, "123.456,78". The problem I'm running into though is when I go to though... I go to Number >...

I'm writing a macro that produces a table from external data, and I want the user to be able to format the report using a table style that they can modify. Is there a way that I can "call" the Modify Table Quick Style dialog from the macro and allow them to amend it? I know that I could create...

Hello am user here since i am not excel magnet hence seeking urgent help my boss said to do as below i have a excel sheet data contain Style Code, Size, Qty, Bin number now we have peak season from next week challenge here is same style code and size OR same style code different size kept in...

We use to search by style code and size, qty and manually removing after material pic from bin what am looking here pl

Hi First post, so please excuse if added items/references wrong. I am trying to develop a Gantt using VBA, I cannot use the Conditional Fromatting style or any style that prevents me from referencing the date cells which have colour or text. I would like to have two sheets. Sheet 1 = Gantt and...

I'm making word doc based on excel list. I'm able to copy and paste the value to word. I have also set up style: heading & color. Here is my working code: Dim wb As Workbook Dim wc As Worksheet Set wb = ActiveWorkbook Set wc = wb.Worksheets("Sheet2") Dim applWord As Word.Application Dim...

I've used pivot tables and charts for years through MS Excel 1997, 2003, 2010, 2013 and just this past week, had an upgrade to 2016. I'm also currently running Windows 7.0 Since my Office 2016 upgrade, all files that I've built (in both earlier versions and new in 2016) that have pivot tables...

As title, is it possible? I think that's the hardest question in Excel history (about style). And I think no one can solve that without build Excel. <tbody> A B C D E F 1 MREXCEL Your One Stop for EXCEL Tips & Solutions </tbody> =MagicalConcat(A1 , B1 , C1 , D1 , E1 , F1)...