#tables

  1. R

    Dynamic table to count amount of repeated words

    Hi all below is a graph i made and the data i made it from only issue is when i update the table the graph doesn't update how can i make this dynamic , thanks in advance DIJKLMNOPQ2Property Investment3Intermediary4Multi Landlord5Property Management6Intermediary7Asset...
  2. V

    Updating Prophet tables using Macro

    I’m trying to open Prophet tables (.fac format), update them on excel and then save them in .fac format such that they can be used on Prophet using a Macro. Please help me out as to how this can be done?
  3. J

    Create VBA to create table for each row with the same start

    I have multiples txt files and I would like create VBA to transform txt in tables. Example: file_01.txt |000|12162020|XXXXXX| |001|421,34|0,50|210,67| |001|523,45|0,50|261,725| |005|| file_02.txt |000|11162020|XXXXXX| |001|400,00|0,50|200,00| |001|100,00|0,50|50,00| |005||...
  4. L

    Sort issue - multiple tables using vlookup or index/match

    hi I'm pretty new to both tables, VLOOKUP and INDEX/MATCH I have four tables in separate workbooks, I have made them tables as my brother has been helping me to add pivot tables to analyse the data quickly when I come to end of season reports I have now played around with adding VLOOKUP or...
  5. N

    VBA to get Excel data and produce XML file

    Can you help me on the below? I have 2 tables in Excel. (images) I want these tables to be exported in XML in a certain format (see code below). <?xml version="1.0" encoding="UTF-8"?> <cbc:CBC_OECD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:stf="urn:oecd:ties:stf:v4"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top