2010

I have a large workbook that I would like to be able to choose specific sheets to save as .pdf and email via Outlook. More specifically: Sheet name: "Purchase Order" and the email address is in B14, SaveAs name in B9 and "Project #" from M4, add a space and "PO" It would be great if the...

Hello, this is my first post here so be gentle :) I need to paste cell values from one column to another via button. Code I use is this: Sub Macro1()Dim myRange As Range Range("AH5:AH32").Select Selection.Copy Range("D5").Select Selection.PasteSpecial Paste:=xlPasteValues...

Hi, I'm struggling awfully with this but am unsure why... I have A1 - 3.4 - meaning 3. weeks A2 - £150 - Daily rate A3 - Week 1 A4 - Week 2 A5 - Week 3 A6 - Week 4 A7 - Week 5 the only variable is the length, this could be anything from 0.2 to 5.0, .2 denoting 1 day in the week, so .4, .6 .8...

Hi! You guys have been extremely helpful as with every problem I come to in Excel, I google it and usually find the answer here. So thanks! This one I couldn't find by Googling. I am trying to create a list where the user will select which "Lanes" to assign to "Zones" -- for example... Zone 1...

Hi all, I'm looking for some helpful suggestions of examples of how to modify my code example if possible. Apologies if this seems in any way a simple fix but I am having trouble implementing maximum subproblem limits in my Excel 2010 macro. I am aware of the StepThru workaround that is...

I am trying piece together various code to create a macro. I am having a problem with one line of code. The error is that object does not support this property or method Where am I going wrong. Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).ActiveCell.FormulaR1C1 =...

I searched this forum for this, but didn't find precisely this issue. I have a spreadsheet with around 415 rows and a few columns. Mostly text-filled, but some numbers. I'm trying to filter some of the text columns using the triangle buttons that appear in my top/header row. When I click the...

I currently have 93,643 lines of a CSV file that I run a PIVOT table on and it works exactly as I want it to. What I am looking to do is from within the PIVOT table be able to adjust the number of ROWs that the PIVOT table uses to calculate its report. Other than having to go in and each time...

I have a sheet that contains a few formulas in each row. I frequently need to insert more rows up top so I copy row 2 (row one is title row) then insert it between row 2 and 3, then copy rows 2 and 3 and insert it again to add a few new rows with the formulas already entered. I'm sure I can do...

Just thought I'd share this nugget of information. VBA based cut/paste of a range containing a form button has slightly different behaviour in Excel 2010 vs Excel 2007. If the source range is hidden the button will NOT be copied when using 2010 but will be copied when using 2007.

I've noticed the fill pattern options within Format Cells is fairly limited. My 2010 Excel version has a total of 18 choices to choose from. I'm curious as to whether there are any available add-ins or custom methods to create your own pattern? I'm in the process of coding a spreadsheet to...

The formula I have in cell A1 is ='New Product Business'!A11. I would like other cells in the current worksheet to be relative to this formula. I came across FORMULATEXT and it seems that by combining this with OFFSET I could achieve what I need to do. However, I have Excel 2010 and FORMULATEXT...

So I have the formula written exactly how it's worked many other times. =VLOOKUP(B3, Sheet2!A:B, 2, FALSE) I have found the value of B3 on Sheet2. I know it exists. I found it using the find feature. I have Sheet 2 sorted. Both Column B on my formula page and the Sheet2 column are are...

Hi everyone I have had a table array formula set up for many years in my main spreadsheet. I also always have my xls set up with "automatic except tables", so the tables only calculate when I want them to, or when I save. A few weeks ago I added several (60-ish) columns to a different tab...

I will start this by saying I don't know much about excel, but I do know that formula for this problem is beyond my skill level and beyond what a simple Google search will answer. The challenge is: I have 5 areas (Cans/Contingent/Kegs/Maintenance/Bottle) that submit daily codes (20 different...

We use Excel 2010 in our workplace and some of our vendors send us excel sheets that have up to 30 or more worksheets within Excel. When I first started with the company a few years ago there was a very helpful excel macro we used that has a very useful feature. When you open any excel sheet...

hi! I am using Excel 2010. BTES worksheet: acct# Oct-13 Nov-13 Dec-13 13245 850 12458 850 45864 12385 1500 MainList - F2= (current month) Based on the current month (which I planned on typing in) on the MainList worksheet I need to count how many blank...

Hi everyone Is it possible to creat an appointment in someone elses calendar? My spreadsheet column B contains all the information needed, I just dont know how to do it. B7 = Date of event B8 = Name of event B53 = Get-In Time (Start Time) B60 = Get-Out time (Finish Time) B90 = Duty Technician...

Hi All, Need some assistance with excel 2010. I have two columns (mentioned below), corresponding to that I need to highlight the weeks cells in the rows on that particular week column (as gantt chart) for which this effort is expected to last. <colgroup><col><col></colgroup><tbody> Start...

We have a relatively large spreadsheet. At ant time there may be up to 4 people updating parts of it. It contains no formulas, but they do use the freeze frame function and some use the filtering tool. Many issues, freezing, lost data, error messages. It has been re built two or three times so...