excel 2013

I have a sheet with a couple of columns. <colgroup><col><col></colgroup><tbody> IndexID Part Number 1,1 3807 1,2 6680 1,3 4440 1,4 2074 1,5 5021 1,6 2298 1,7 1572 1,8 3379 1,9 8832 1,10 2627 1,11 6802 1,12 4395 2,1 7504 2,2 4109 2,3 9803 2,4 5461 2,5 2052...

Hi All I was wondering if anybody knows a quick and dirty way for an excel (2013) user form to populate an access (2003) database. I have created the database in access and they match the questions in the user form but i'm having difficulty in getting the to to communicate (a connection has...

Hello, I have problem with freezing/unfreezing panes in a specific workbook in excel 2013, windows 10. The workbook and worksheets are protected and contain VBA code. I can freeze and unfreeze panes in excel 2010 windows 7, after unprotecting the workbook. In 2013 button to freeze panes in...

Hi There I'm new to excel and was wondering if you could help me :0 So I have a spreadsheet with 2 worksheets. The one has 3 columns: Brand, Date, Traffic The other one contains a table that should only show the traffic amount my website received based on the brand and date in the worksheet...

Hi, I have a 2013 access db that is pulling info from a 2013 excel sheet that is updated frequently. I had to do some digging to find out how to parse and convert data from one cell into multiple cells so that I could properly query the info in access - all date and time info is in one cell...

Hello all you experts out there, I have this code and it works for the most part except for the password. The code itself works but when I go to unlock the sheet it doesn't ask me for the password. So it doesn't seem to add it in. Can you please check it out and see what I am missing? THANK YOU...

System: Windows 7 Professional 64-bit Software: Excel 2013 Greetings Everyone! I have been trying to manipulate snippets of code here and there to find a solution to this project. I wouldn't say that I'm a VBA novice, as I am not actively trying to code, rather than see what works from other's...

Hello, This is a continuation of a previous post, but I thought I should start a new thread since this is about SELECT CASE. (https://www.mrexcel.com/forum/excel-questions/1021927-excel-vba-use-consecutive-if-statements-use-if-elseif.html) I'm now using SELECT CASE code to do 2 things: 1)...

Hello, I'm trying to create code so that when a user enters an ID in A2, the city will autopopulate in B2, and the person's name associated with that ID will autopopulate in C2. <tbody> ID (A2) City (B2) Person (C2) N11111 Airville John Doe </tbody> ?? Does it matter whether I list...

Hi Guys, I have a code that updates my named range "GrandTotal" which stores my Subtotal row from a Main Sheet. The Main sheet has two ranges of data, the main range A6:H144 which updates each day, and a lower data range A146:H152. I am trying to have the code for Last row only look in the...

Hello All, I have code that copies a subtotal line from a main sheet then pastes it on everysheet in my workbook and it used to paste the formatting but now its only pasting the values/formulas and not including formats. Here is the code with a comment on the line I need updated Dim ws As...

Hello All, I am working on a piece of code that will look at a specific sheet and if there are merged cells present run a code to remove all merged cells and move a header, if no merged cells exist on the sheet then do nothing. Here is what I've come up with but need the "Case" or "If/Then"...

I'm trying to set the name of a worksheet using the following code, and it's failing to process for some reason. Can anybody help me out with this? Sub CreateNew() intTabs = Worksheets(1).Cells(18, 2).Value For i = 1 To intTabs strWsName = InputBox("Please name Sheet" & i & "."...

Hello all, I am working on a piece of code that currently works fine if you trigger the code sheet by sheet manually, but when I add a loop code it keeps entering the subtotals in the same sheet over and over again? Any help is appreciated! Sub forEachWs2() Dim ws As Worksheet...

So, I have a code that I have been working on now for 2 days and have hit a roadblock and not sure how to fix it. I am hoping one of you Guru's will simply look at it and see a line of code that is entered incorrectly or something. So here it is Sub Subtotals() Dim sht As Worksheet Dim subs...

I can't sleep, this is driving me nuts <colgroup><col><col></colgroup><tbody> Dieter Adriaensen € 4,820.40 Sammy Bogaert € 3,716.60 Griet Coostermans € 2,190.90 Andy Peeters € 3,170.49...

I am working on a project where I have a range of cells (AB9:AB27) and anytime there is a change in one of these cells, I want it to calculate that specific cell and the one to the right of it. I am using comments in the cell from a drop down, which work great, but because I am calculating an...

So, I'm doing a true-up calculations and need the amount to be summed up by their location and then subtract from what was actualized to what was projected. Location is done by doing the "=RIGHT(A3,2)". And as you can see from the DATA SHEET, not all the location and media type that was...

I'm using Ron de Bruin's code for merging workbooks and have modified a couple things. For one, I changed the code so that rather than open a new blank worksheet, I want to use the already open excel file in which I have some custom headings, not the headings from the worksheets I'm merging...

All,I am able to group dates in a PivotTable fine, the problem I have is when a month has no data, but I want to show the months with 0 data.For instance I am going from July 2014 - July 2015. I group by year and month so it shows the data properly. August 2014 has no data, but when looking at...