newbie

As the title suggests, I'm trying to sort a sheet of data based on a single column, and then have further entries automatically sort. The data has columns A-L, I would like it sorted based on column K, discounting the headers which are in row 1. The values in column K are 1,2 or 3 and there are...

Hi, is there any way to prevent user to open an file in an older version of excel? Have a file created with 2010 version, and dont want the users to open the file in older versions of excel since some functionality that I need to have is lost then...

Hi, want to check if a cell changes, and based on it´s new value perform an action. Tried with Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Target.Worksheet.Range("D1")) Is Nothing Then If Range("D1").Value = "1" Then Range("B4").Select...

Trying to copy data from Input sheets to a Summary sheet with this code: Dim Sh As Worksheet For Each Sh In ActiveWorkbook.Worksheets If Sh.Name Like "Inp*" Then With Sh .Range("A77:A146").Select Selection.SpecialCells(xlCellTypeFormulas...

In my worksheet I created code and a module so that when I double-click cells in column N a userform will open up. I need to pull information from the other columns in the same row that was used to access the form to populate text boxes in the userform. I am new to <acronym title="visual...

Hi, quite new to VB. I try to run a script when any of the cells in a range changes with the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("B5:F5")) Is Nothing Then Application.ScreenUpdating = False Sheets("Overdue data").Select...

Hi, Newbie here - would appreciate anyone's input into how we could accomplish creating 'statement' type "mail merges" (couldn't think of a better term for it) using powerpivot and or Powerview in Excel 2013. Basically I would like to know if it is possible to have both an interactive...

Hi guys - hope everyone's well! Newbie here... :) :eeek: I have one worksheet where there are records (rows) with 4 fields (columns) for 8 days in a month, but none of the others. I have another, pre-existing worksheet where there need to be records for ALL days, even if the values returned...

Background: I'm trying to help some of my associates keep track of a particular account. There are four primary types of customer interactions they can perform (Activations, Upgrades, Accessory, Maintenance). What I would like to be able to do is have the Consultant choose their name, enter in...

Hopefully a simple one. I'm trying to work out what criteria stops this bit of code. My understanding ov VBA is pretty basic..... So, In the MSP Data worksheet, from cell C4 - it's looking for 0 data then moving to another cell. Basically - what's it doing in terms of moving and why is it...

Hi, Apologies if this sort of thing gets posted all the time but I really do not understand the terminology associated with what I consider a difficult issue, so I'm asking for your help!! :) I have a spreadsheet with rows of personnel and their locations that I can filter to show only one...

I need help on a database project for work. We have an excel file with multiple worksheets on it. The primary worksheet contains all the data (The other worksheets are all linked to the first worksheet for data) I need to link all the information to an Access db for easy access and to keep...

Im trying to make a tacker fro all my works training that we do, an example is below, the dates are when they did the training, and theh months are the frequency of the training. A B C D E F G H what im trying to do is use conditional formatting to turn the dates yellow when they are...

Hello everyone. I'm very new to using userforms in excel. I want to create a simple userform that will pop-up when you click on a cell in a worksheet that will ask three or four simple yes or no questions and score the answers yes =1 / no = 0 and then return the score in the cell clicked. Can...

Thank you for taking the time to read this post. Let me start by apologizing if this post is redundant. I have searched the forum for similar questions but have yet to find one that specifically addresses my issue. I am an inexperienced Excel user, so the terminology is sometimes a bit beyond...

I have a simple macro I need some help with. I want to spin through a row range of cells (O2,X2) on a specific page. As I spin through, I want to check a specific cell in that range (S2) and see if that cell is either NULL or has a zero (0). If either is correct (NULL or 0) then delete the...

Good Morning Everyone, I am working on my first VBA project here at work. I need the following. Copy Data from Worksheet "WORKSHEET" Range is ("B4:B33") The data in this range are sum calculations. I only want to copy the value, not the calculation so a paste special seems to be needed...

Hello All! A newbie here. I appreciate any help. I am actually quite good in a # of areas - but not in VLookups. I basically have two tabs with similar lists of customers and misc info. One list has addresses and the other doesn't. Each customer has a customer # reflected on both tabbed page...

I need to have the page number automatically entered into specific cells in my sheet. a header or footer wont work here. i have 170 page in the sheet wich on them have different items. each of these item codes get recorded on a different sheet including wich page it is on . for reference and...

Hi folks, I've installed an Add-in into my Excel 2003 and am attempting to record a macro. The macro records everything that I do before and after the Add-in runs, but it doesn't record the add-in! (sorry folks, noob to vba) Am I missing something? :confused: Why can't I launch the add-in...