labelled

  1. T

    Dynamic formula via VBA?

    Hello, I hope someone can help; I'm sure this is fairly straightforward but I'm not that far along the VBA learning curve so please forgive me if this seems like a stupid question. I have an Excel pivot table. I need to use VBA to add certain calculations to the far right of it (the...
  2. M

    CUBE function/s to return Timeline selection

    I have a Timeline that has a number of connections to Pivot Tables that are driving several charts. I need to report on the dates selected via the time line but I am unable to get the CUBESET functions to work. The Timeline is labelled as DateReceived where the shape can be named (same place...
  3. F

    Macro to save 2 sheets in a work book (not all 6) with no formulas to reduce file size

    I have a spreadsheet which is 64000kb which I want to use asa data base. What happens is the user opens this, input an account number andseveral lookups extract data based on that account and then the database issaved as a duplicate copy but naming it using a set file name “D2” and in a...
  4. D

    Data from two sheets to a third, then compare and add together if same

    I have two sheets (named sheet1 and sheet2), column B is labelled $ and Column K is labelled Buyer. I would like to take the buyer names from column K of both sheets to sheet3 column A and the $ amounts from column B of both sheets to column B of sheet3, then if the names in column A are an...
  5. S

    Consolidating Data into a Single Column

    Firstly thank you for taking the time to read. The issue I have is that I have been given a spreadsheet that is a report generated from a survey but the data is all over the place and spans across different columns. For example Column A is labelled Age Range and has data entries for those...

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