+ Reply to Thread
Results 1 to 2 of 2

Multiplying column layouts in dozens subtables?

  1. #1
    Registered User
    Join Date
    12-19-2019
    Location
    finland
    MS-Off Ver
    MS Office 365 (ver.1911)
    Posts
    1

    Multiplying column layouts in dozens subtables?

    I do annual statistics and so the rest of the year I prepare the ground for next year. But the statistics are done in monthly cycles and each month is divided into weeks. The problem is that every year the number of weeks in a month changes. It's a terrific job to create a new table, especially when there are dozens of subpages that are summarized on the main page. Does anyone know how to get a column break from the main page by copying using formula. Copying the whole table is not possible because different inserted formulas. Thanks in advance. I hope my "googlish" is not getting anyone mad.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Multiplying column layouts in dozens subtables?

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Possible To Save Pivot Table Column Layouts?
    By seethesun in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2018, 10:37 AM
  2. How to Automate Updating Column Headers Across Dozens of Spreadsheets
    By Startup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2013, 11:12 AM
  3. Simplify dozens of IF functions in macro
    By Mladjone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2011, 07:23 PM
  4. Working In Dozens
    By moe19 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2008, 02:41 PM
  5. Filter data into multiple subtables
    By rishid in forum Excel General
    Replies: 0
    Last Post: 08-15-2008, 10:41 AM
  6. Multiplying A Whole Column By 2 ??? Help
    By joesther37 in forum Excel General
    Replies: 5
    Last Post: 12-31-2005, 06:30 PM
  7. Working with dozens
    By HDSalinas in forum Excel General
    Replies: 7
    Last Post: 07-12-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1