excel & vba 2013

I'm new to VB, and need your help if you have time. I have reviewed all posts that relate to my inquiry, and cannot make a code do what I need it to. My workbook has sheets: summary, teacher, template, and 30-40 other sheets (varies). I need a code to copy each result in column Q of each...

Sub Print3() Dim sht As Worksheet Dim CurrentSheet As Worksheet Dim cht As ChartObject Application.ScreenUpdating = False Application.EnableEvents = False Set CurrentSheet = ActiveSheet For Each sht In ActiveWorkbook.Worksheets If .Name <> "CHART OVERALL" Or "CHART TL" Or "CHART...

Hello, I'm new to VB, and cannot get my code to do what I need. I'm using Excel2013. My workbook has one sheet (Sheet1), with columns A - K, and 307 rows (one row per student). Column H is a teachers name. I need my code to create new sheets for each teacher (col H), and copy all student's...

I am trying to use date from a cell (text) to filter my pivot table and thought I understood well enough to complete it but can't seem to get it right. It is probably something simple but I can't find the solution to the problem and have tried different methods to make it work but nothing is...

Say you had the following data in "A1"; 12-24-16 was Christmas, 03-15-16 was another day 07-13-16 people didn't always use commas; 09-27-16 or whatever type well. Could you get the data extracted like this?: <tbody> A B C D E F data thats above 12-24-16 03-15-16 07-13-16 09-27-16 open for...

Hi all, I have two tables on one spreadsheet (LiveProjects and TenderProjects) and I wish for a new row to be added with the data entered from the UserForm. The coding I have done for this works but what I particularly need is that depending on the 'Status' selected from the StatusListBox, the...

Hi, Was trying to get this working. Cell(17,2) has a date and is being compared to the present date. If Present date is greater than the date in Cell(17,2) it will shoot a mail. Sometimes this code is working good but sometimes its not.. When runs it gives this error after completion...

<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Hello, I am using Excel 2013 on Windows 7 (PC). I have a workbook with...

Hi - I have a data set that is organized by date in column A and then in column B it is binary data of 0's and 1's where 1 means the customer was declined and 0 means it was not. Each week I calculate the rate that customers were declined and plot that out over a 12 week period. I now would...

I have this code that opens a workbook on a local website on our intranet and then copies the sheet into a local file. Workbooks.Open ("http://teamspace.****.com/sites/****/****/Shared%20Documents/Lookup.xls") LastRow = ActiveSheet.Cells.Find("*", , xlFormulas, xlPart, xlByRows...

This halfway works and I get the error around the 4,000 record mark. Sub Row2Column() Dim rngData As Range, r As Range, myDate As Date, strName As String Application.ScreenUpdating = False With Worksheets("Sheet0") .Columns("A:B").Insert Set rngData = .Columns("D").SpecialCells(2)...

Home can I get row data to column data? The information can only be whats listed on the top of the instance. Each instance is separated by a blank row (10,20) I will provide 3 instances as a reference. [/IMG]

Hi, I´m don't know how to use vba to copy many excel files in to a access data base. I got a lot of files, the sheets got the same standards but different names and located in the same path.

OK, I really did look for the answer for this, but after about 2 hours of reading posts, I'm no closer to the answer. :( I am trying to open a second workbook from the one with the VBA in it. I need to set that other file's name in one place so someone else could edit my code if they exporting...

I am trying to merge cells an add a thicker border based on values in a list. The values in the list start at 1 and go to a maximum of 10; however, the list can stop at any number before 10 and restart to 1. I have the current code inputted in my properties: Sub merge() Dim srw As Long, frw As...

I have data set on excel worksheet like this: name | date | amount NM_1 | 01/01/2016 | 100 NM_2 | 01/01/2016 | 5000 NM_1 | 01/02/2016 | 70 NM_1 | 01/03/2016 | 50 NM_3 | 01/04/2016 | 400 My goal is to find the amount where name = NM_1 and date <= 05/01/2016: How can I find the...

I have been trying to import an excel table of over 281,000 rows and 92 columns to a fresh Access db. No matter what I do to achieve this, I end up seeing "The expression you entered refers to an object that is closed or doesn't exist". I thought it's due to memory problems and so freed up 8 GB...

I am trying to add the round function to an existing formula within my excel file. I want to add it to my if statement currently functioning as a look up reference to a range of data. However, the range is not in chronological order and I would like to do a quick update to the entire population...

In Sheet1 I have case-specific data (A is sitenumber, B is sitetypes that are present in the specific sitenumber): A - B - C 1 - 1H31 - ... 1 - 1H71 - ... 1 - 1H93 - ... 2 - 2H34 - ... Sheet2 contains general data about all sites, including the species that live there. Multiple species can...

Is there a way to count how many data is enter into a column for the most recent input?