report

Hi need some help please I have the following VBA for a report which copy's over Specific data from one workbook to another workbook in therange & tab I need it to, however I would like it to automatically know thefile path & report I want the data copied from, this code currently askswhich...

Hey guys I am having a roadblock in creating a pivot to analyse the data. I have a report in the "Details" tab and calculations are done within the tab. For example, I have a total cost for a line item by month (from column U to column CZ) and the cost is then allocated to different...

Can anyone provide me with a quick way to remove every other row in a spreadsheet report?

Hi Guys, I've got a question about RLS in PowerBI. My problem: When i give someone access to my reports without a role, they see all data. Is it possible to set my dataset to like a RLS only? So when someone without a specific role opens the report, they see nothing. I ask this because of...

Dear Forum, I need a little wisdom here please. I have managed to create a working Marco that filters, formats, deletes etc. a worksheet report. The Marco name is: Daily_Report_Filter Each day we need to pull a report, the report data and structure is always the same but the file name...

I have attached links to two spreadsheets: "Before" and "After." Here is what I am trying to do to "Before" so it ends up looking like "After." Separate dates as follows: if today is 9/16/19, I need the spreadsheet to only show 9/16, 9/17, and 9/18, removing all other rows of data and...

I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price inc. GST Allocated to Date report...

Hello, I'm looking for a formula that would accomplish the following. If the date in worksheet (DRP Payable "J") is between the start (A3)and end date (D3) of the pay period listed in (Pay Period Report), I would like to list the results of J,G and H from DRP Payable to be listed in Pay Period...

Hello Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...

The following code will open the specific file I need: Sub OpenRoutingOpen12() Application.DisplayAlerts = False Application.ScreenUpdating = False Application.AskToUpdateLinks = False txtdate = Format(Now, "m_d_yyyy") & "%208am" Workbooks.Open...

Hello, I need to email out a list of individual reports to specific addresses. The reports are located in C:reports and all have the same naming convention. Below is an eg of the spreadsheet and the data. Paste starts from A1 <tbody> AssetName Driver email Manager email1 Manager email2...

Hi All, New to VBA/Macros trying to learn whilst piecing together examples i've seen, think what i've got works but is long winded and needs a different macro for each split and will require tweaking if/as the report changes. Im trying to break out a report in 1 worksheet into 5 different...

I am trying to convert this report number to a date and time, is there a single formula that can achieve this or do I need extract the numbers using left/right formula? W3_20190903_230338 = Sept.3,2019, 11:03:38 pm

I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to...

Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...

Hello. I am looking for some vba code to add the day of the week to the below wording and to work when printing for all sheets in a workbook. Currently it says in the footer: Report Dated: 08/30/2019 Format for wording is: Bahnschrift SemiBold Font, SemiBold Font style and 9 size. Want it...

Through the years, Excel macros have run slower and workarounds to speed them up have appeared on this site (screenupdating, visible, calculation properties) but I have seen nothing to date on this recent (for me) situation. Starting June of 2019 the macros I run doing copy/pastes slowed way...

Hi Is itpossible to create a code that can copy rows from a data sheet and paste to areport sheet if there is a partial match? Data is a staff record with data in 11 columns and about 450 rows. In column 1 (A) are names with first- middle- and last name in the same cell. For example, if you...

Hi all, I'm working on a spreadsheet for a friend who uses a Mac. I have zero experience on a Mac so I'm hoping I could get some help please. The below code works on my PC but it fails on his Mac: Sub ImportRawReport() Application.ScreenUpdating = False Sheets("RawReport").Select...

Hello again MrExcel, I need to filter reports where the filter Row is in a different row on each report. The code below has the filter Row in Row 7, another report has it in Row 10, and another has it in Row 5, etc, etc.. Is there a way to have the macro search for "Call Type", select the row...