Search results for query: *

I have been thinking about this for awhile, and I am not sure where to even begin. I have a report like the attached that I produce every month. I would like to keep the information that pertains to the Group Name together on the same page. The last row pertaining to any group is the Group...

Hi, I have the following code which just highlights all the data in a worksheet. I want to take that data that is highlighted and use it to define a name such as CurrentMTH, I have a few things none of which are working. Any thoughts? Sub DynRange() Dim sht As Worksheet Dim LastRow As Long...

Hello and thanks for looking: I have the following 1) 15 or so excel files in a folder like the attachment BostonSPS. The only thing different is the name of the file and the number of rows can month to month. This is important because I need to have the code look to the last row (and it is not...

The Following Code Works Perfectly... It takes Data from a Table and loops through the table and based on Group (Group is a Company Name) saves it in the specified folder. In this table (TA_Accident_NewEnrollment) I also have a field called State. What I want to do next is using the...

Hello, I have the following code which does what I want which is it loops through a directory of excel files insetrs a worksheet based on a name I give it and copies and pasted data from the worksheet called Currentmonth into the new worksheet and deltes the data in CurrentMonth. However it is...

I am trying to writing code that will perform the following: 1) Open an excel file located in this directory: C:\Users\jhaberme\Desktop\DailyFiles 2) Insert a Colum in Column A 2) Name the Column Group 3) Fill in the column beginning at A2 with the Sheet Name 4) Save and close the File as...

Hi, I Have the following code that basically looks a value in BC13 and BB13 and puts that value in c4 and c6 respectively. If the Value in BC however is HealthAlliance then I do want to run the code, so that is how I cam up with the following: If .Range("bc13").Value <> HealthAlliance Then...

Hello, Attached is a Access Database which will process the Data (By the field called GroupName)in the TA_Accident_NewEnrollment table and create four separate excel files each uniquly named based on the Group Name. My goal is to instead get this data onto the Excel file called Accident at the...

Hello and Good Morning, I have attached a file which shows data that is unformated. (see From WorkSheet). I am trying to format the worksheet to look like the To Worksheet using VBA. Here are some notes and that I have: 1) For each change in Office Location I need to insert two rows and sum the...

Hello, I have the following docmd statement the I need to set the location Id to 0000002 where the Office is St. Margaret's Center DoCmd.RunSQL "UPDATE CurrentDay_Template SET CurrentDay_Template.LocationID = '0000002' " _ & "Where (((CurrentDay_Template.GroupNo) = 'CFDS') And...

I have a query called: Qry detailrps, which I have code below that loops and exports the query based on a unique valu in the column called Group_name The code creating unique excel files with the respective group name but no records for that group are in the file. How do I get the underlying...

Hi, What I have: I have a table which has a say a thousand records. A column in the table is called Group and say a hundred records in group1, a hundred records in group2 and so on I also have a column call Order each group is a assigned the same order number. I also have query that is a...