report

Hi, i'm trying to write some VBA code to open several workbooks, copy a column, and past into the book I run the macro from. I need the data I copy over to all go into the same column. Here is my code: Sub MeToo_Paste() 'Assign Report Book Dim x As Workbook 'Assign Source Books Dim y As Workbook...

My report's final item is a chart image which is in the report footer. I don't want the page header and footer displayed here. I thought it would be easy - I set the report properties Page Header and Page Footer to "Not with Rpt Ftr". But although that works for printing (i.e. exporting to PDF)...

I made an excel add-in that creates a report from a site automatically. I would like to add a form control to that report linked to another sub in the add-in file automatically. This is so the user can run another report just by entering a value in a specific cell and pressing the form...

Dear all I have currently a macro which I run to generate a report. Once finished the report needs to be sent to several people. The email list of people, subject of the email and body text are saved under the tab "email" as you can see below I want to also only send the tab named...

Hello, I'm trying to copy two worksheets from one workbook to another. This seems to be fairly straight forward, but for some reason, I can't seem to accomplish this with a variable sheet name. I have set one of the workbooks to "Report" and the other "Edit" The "Edit" workbook is currently...

Good Morning, I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below. *** Put a date in a cell...

Hi All, I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables. I seem to have maybe identified the sheet...

Hi, I have some task - that looks like very easy, but... I cannot find solution :( I have data like this: <tbody> Column1 Column2 A No A Yes A No B No B Yes C Yes C Yes C No </tbody> And want to get report showing the percent of Yes/Total: <tbody> Column1 Yes/Total A...

Hi I'm trying to flag data that appears since the last time the report was refreshed. For example, if the sale date was 28/07/19, flag this row as "new since last refresh", if the record wasn't present on the last report version. Any ideas please, guys? I've Googled about and looked through...

I have a common access report. One of my text boxes is ="If you have questions about this report, please contact: " & [CompRptCntctFirstNm] & " " & [CompRptCntctLastNm] & " at " & [CompRptCntctPhone] When I run it I get something like the following: If you have questions about this report...

Hey Dear community, I am using VBA+ formulas to analyz sales data ( about 1000,000rows ) it takes 7-8 minutes for calculation, i wanna know if there any other way to make it faster? because i need to calculate this report daily. I use following VBA for 80-90 different ranges on that report...

Hi All, I have a two sheets a master sheet and a weekly report sheet. I need to firstly recreate the previous weeks weekly report sheet based on the cell value i put on the master sheet For example Column A ( Master Sheet ) is the week numbers A2=WK27,A3=WK28 Etc when i add WK29 into cell...

Hi, I have a workbook with a daily report Sheet. I (move and copy) it each night and rename the file to the "Daily Report- mm/dd/yyyy, date of that work day. That file gets stored in a job number folder on the desktop and in that folder is another folder named Daily Reports. I have another sheet...

I'm building a Macro for a project. It's going really well but quite a learning curve. The project has about 20 outputs. The first steps for all 20 are the same, but at a certain point the process diverges for each, mainly in terms of producing a Pivot Table with different fields (but all from...

Customer produces and sells widgets (CW). We sell a report about the performance of the widgets. I have a spreadsheet of customers with one report sale per row - Customer Name in Column A, Product Name in Column B, other data (irrelevant to my question) in other columns. Customer may have...

Hello forum, I have been try to extract unique values of account numbers from a large list of varied data based on two dates that will vary depending on the dates on another sheet. I have started by simply trying to extract the account numbers above the first date criteria but have run into a...

Hello All, Is it possible to run MS Access report export (to MS Excel) by a user that does not have MS Access? I need to share report that uses data over ODBC to multiple remotely located users. Not all of them have MS Access. I was wondering if there was a way they could run export that would...

Hi, I created a pivot table with and dragged a column under the report filter. On the top of the Pivot table, the pivot table normally has a filter above the report filter, in this case it just shows a drop down list, no filter. Can you please tell me what I'm doing wrong? Thanks

Hi guys Is there a way to link an excel spreadsheet to a website? Each case I work on has different dates. This tells me how many reports I need to download from a company internal website. When I go on the company website, I select the report and use cute pdf to save this file on the hard...

I need to get report txt files into excel but can't figure out the best way to do this. Sometimes over 100 pages are in a single report and every page contains the headings and title info as shown below. I've highlighted the main info needed if getting the other data into cells is too...