table format

  1. M

    Paste data into new file works, but not if formatted as table

    Hi everyone! So I have this database, wich I got from and =IFERROR (INDEX formula. I have 50 rows, and some of them have results, others not. When I copy this to another sheet and paste it as value, Excel sees the cells without result still as NOTBLANK. This changes when I double click on...
  2. P

    Table height to match PivotTable

    Hi, I've tried in vain to work this out myself and cannot find a thread that seems to match my query, so here goes: I have a PivotTable that contains product codes and monthly sales, I then have a table to the right of that (no column gap) that contains various formulas. My questions is: is...
  3. A

    Excel table formatting in A4 printable format

    Hello Folks, I am trying to create a table format where i have setup the page layout to A4 size. I populate the table with data that is received from the server and that is only single column,everything works fine. What i want is when the data is inserted into Col A i want the data to fill the...
  4. E

    How do I format an individual column in a table ?

    I have a table with a large amount of data. I am wanting to change the format of individual columns so that they have their own unique style from the rest of the information in the table. Most of my table is format in an orange color. Darker for header and then the rows with an alternating a...
  5. J

    VBA to build table based on 2 spreadsheets

    Hi Guys & Gals - I really need some with VBA. I have two spreadsheets and i need to build a table out of them. First spreadsheet tells me which builds are against which equipment numbers (the builds are the A numbers across the top) <tbody> Eq No. A465 A506 A507 A508 A510 A511 A514 A525 A561...
  6. A

    Autofilling a Table that has a Changing Position

    Hello all again, I have two tables in one sheet that both change their amount of rows based on a certain user input. The first table changes rows based on a person's input by an input box, and the second table changes rows based on a certain value from the first table. The second table then...
  7. E

    using macro to format arrays of varying sizes

    Hi, I am new to VBA and I am just trying to save some time while formatting the tables I am constantly doing (I don't like the pre-formatted excel tables). So I recorded the following code. The problem is that it only fits a specific dimension table (19R X 8C). I need it to fit a selected range...
  8. H

    How do I set a table's range to automatically adjust to source data?

    I cant figure out how or if it is even possible to have a table automatically adjust its range or the number or rows it has based on another table I have two tables: Table1 is raw data that is added two daily Table2 has formulas with column header references to Table1 that processes the...
  9. S

    Stacking tables using vba

    I have 3 tables all in one worksheet that are linked to source data which is refreshed daily. Each table has the same column labels and I would like to stack them into a single table using vba. I currently have 2 problems: I would like to copy from the second row down in each table to the last...
  10. T

    Word 2007 VBA AutoFormat Types

    Morning all! So this is a Word 2007 VBA question, but I haven't found a forum like this for Word, yet. If you have any suggestions as to one, I'm all ears. I'm creating a table in my document that I want to format to look good. Word, apparently, has certain predefined formats. Word's VBA Help...
  11. U

    Extending A Table Range

    This should be so simple that I am embarrassed to ask for help. I imported my data and I have a macro that updates the data. Nothing new until new items were added, creating new rows at the bottom and now the Table Format does not include these rows. There are so many formats available that I...
  12. P

    Table Format and Data Validation

    my data in Table Format... Column A = List of Countries Coulmn B = List of Provinces/States Column C = List of Towns On my report table, I want to use or apply validation such that when I choose a country, only the list of provinces from that particular country appears on the dropdown list...
  13. E

    Excel 2007 not picking up Calculations as part of table

    Hi, I have a question that is tough to explain, but I'll try my best. I have a sheet called "Data" & this is a SQL query that I pull using VBA (Rows A:J). I then do some calculations in VBA in Row K (Change from € to $). When I run this macro, my Excel 2007 doesn't show column K as part of...
  14. eschiesser

    Slight Table Formatting Issue

    I want the first column to be formatted like the column headers. Despite my best efforts, i cannot make a custom table format that will do this for me! I can obviously just fill those cells, but I have a lot of these tables, and that would be such a pain in the butt! I know this is a tiny...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top