reports

I am trying to use the WEEKNUM function but it miss reports the week. example cell function in B7 =WEEKNUM(B6,11) using a date of 29/12/15 reports week 53 (Week 53 is December 28th 2015 to January 3rd 2016) but put a date of 01/01/2016 reports week 1?? It is still part of week 53...

I have several tables in separate workbooks that different users populate based on the stage that a project is in. MainTbl: holds basic info on a project QuoteTbl: info on status of the project's quote info EnggTbl: info on engg for projects FabTbl: info on fabrication for projects AdminTbl...

Hi I have the current path to clicking a button in a website. is there a way I can define this path to click on, e.g. getelementbyid? $x('//*[@id="header"]//div[text()=" Extract Reports "]') Appreciate anyones help.

Good morning all, i searched the forum and found similar results to what i need but not quite meet the criteria for my specific issue and i am hoping that you guys can help me with your knowledge. so what i have is a series of reports that i update every morning and they all need to have data...

I have a workbook with a worksheet (Reports) listing all the reports I want to print i have another worksheet (Calcs) which has all formulas pulling from other data sheets...this sheet has a validation drop down reading from the list of reports on the reports tab...once you change the drop down...

Hi guys, We receive 7 different reports which are copy pasted in a single workbook in different sheets(as per reports name), and each of the report is allotted among 4 members and processed, Such that all 4 have to work on all the 7 reports. At the end of the day I need to collate the 4...

Hi, I use a worksheet where I reconcile data from different reports. All repports have only 1 worksheet and use the same format. VBA uses GetiOpenFilename with Multiselect enabled so ultimately, I would like Excel to import data from 1 workbook at the time and then continue with the following...

My problem is I have a number of reports and I have a macro that goes through each report and extracts data from each as needed, these reports however are made by separate individuals while most of the formatting is the same in each the first 4 rows of information is sometimes scatter within the...

I have a mail merge directory that i've created using MS Word, which pulls data from an excel spreadsheet of project team itineraries. The data is constantly being updated - people quit, locations close, people run over schedule at a stop on the list, and so the reports need to be constantly...

Dear all I need help. I have a pivot table which generates customer statements. I have 125 customers. what I do every month is I manually select each customer in report and save file as pdf and name it whatever name is in report filter (obviously the customer i selected) Now I know this can be...

Good Morning Everyone! I'm about 4 months into learning VBA so I'm still a beginner. I am trying to write a code and I'll do my best to explain what I'm trying to do. I have a worksheet with multiple columns of financial data going down the columns (In this case columns C,E,G,I,K....). Next to...

Good Afternoon, I am working on a project which has a "form letter" that provides information about their record. Depending on the number of items in their record/profile their letter could be one or more pages. What I would like to do is (a) print our masthead (which is an image) on page one...

I'm a teacher, and I really enjoy finding efficient solutions for some of the tasks that my job requires. I had an idea about how I might be able to efficiently produce student reports, and need some help in working out how to do it. I'm relatively new to Excel, but am keen to learn. I'm...

Hi all, I have seen many advanced spreadsheets that make use of a single Data sheet, where data is only pasted or imported from some data source and drives the rest of the workbook. I have set up a data sheet that records the type of customer, their status (i.e., recent customer, not-recent...

Is there a way to export a list of forms or reports using VBA to Power point? I currently can export a list of forms to PDF but would like to have the ability to put these over in power point. The forms contain graphs and when I copy the PDFs into power point it makes them fuzzy. Like a bad copy...

Hey Guys, I am pretty new to VBA and have never really had any training with coding for it. I am setting up an automated report but am having trouble getting the application on time event to run more than 24 hours. The Reportupdate Sub updates quite a few cells based on the current, that why...

I have been trying to use excel to generate quarterly TECHNICAL report printouts related to preventative equipment maintenance. We use a specialized program to generate the actual data for each individual report, so there is no accuracy nightmare with the actual data. The program generates a...

Hey all. I have made a table on excel that gives the daily business brief for each month. I will be inputting expense and production data into it each day. I want to generate daily and weekly reports that gives the business brief for that day or week and can be printed on one page and sent to my...

Hi everyone, I have created many reports in the past using button that I created. All the reports that were generated by the macro button is showing in front of other open windows (forms, query, etc.). This time when I created a new database, the reports I created display on a tab - not...

Hello, why doesn't this work? I am trying to update several fields on a form, the problem is this: Forms![frm_CreateContract].strField Here is my code: Set db = CurrentDb Set tdf = db.TableDefs("tbl_Adendumn") i = 1 For Each fld In tdf.Fields strField = "ITM_1" & i & "_" & fld.Name...