2007 excel

I'm scratching my head trying to see if this is doable and how. I have 2 worksheets (of many) in this project. The following is a super simplified version of problem. Sheet A is randomly sorted and is presented to the user as a logical grouping of ITEMs ITEM COST AGE apple 5,000...

Hello Everyone, Many thanks in advance. I have an issue where by a data set on a XY scatter graph is joined with Linear Trend line. It is used to show the routes a ship takes and the scatter graph has a map as a back drop, x axis is longitude and y is latitude. The longitude (x axis) starts...

I have an excel file with a list of customer names in column A and a list of dates for every transaction they've made in a given year in column B. I would like to find a way to manipulate this data so that I can determine if there are customers who have only shopped between 4/1 and 6/30 of a...

Hello all, File_Name = SK & "-" & Year & Month & Day & "-" & Daily_Drawing_Number & " BOM" & Rev_Letter & ".xlsx" Application.Dialogs(xlDialogSaveAs).Show (File_Name) I am trying to force this to input the specified file name into the dialogue box for the save as box. However it...

Hello all, I am looking to print to pdf from column A to Column R, starting at Row 2 and ending with the last cell to contain text or is formatted. I am new to VBA and havent been able to figure it out myself or understand examples of similar questions. I would like it to take the width and...

I have the below code which selects all data below A5, includes the 17 columns on the right of it, and then offsets by one so I don't clear the title row. <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console'...

Hi, I need to copy some data every month, paste it into a spreadsheet and then save it as a new file with updated date Sub InvoiceBackup() Sheets("ASM001").Select Range("A1048576").End(xlUp).Select If ActiveCell.Row = 5 Then Exit Sub Range( _...

<tbody> <tbody> Actual </tbody> <tbody> Current </tbody> <tbody> Needed </tbody> <tbody> Store A </tbody> <tbody> Prod A </tbody> 3 3 3 <tbody> Prod B </tbody> -5 <tbody> Prod C </tbody> 7 7 7 <tbody> Store A Total </tbody> 5 5 10...

Hi I have recently upgraded excel from 2003 to 2007. Now a report that I run with quite a lot of VBA-code is not working. When opening the file I get a warning that not all content can be read but if i trust the user excel will try to repair the file. after pressing yes i get this...

Please be kind, as I am new here and new to VBA in general. I have an Excel 2007 problem I’m trying to solve with macros and I’m hoping someone can help me with the code. Our company is structured as follows (except on a much larger scale, obviously):</SPAN> <TBODY> Mgr A Supv A Supv B...

On Excel 2003 I was able to set different colors to specific characters on charts titles using a VBA command like this: ActiveChart.ChartTitle.Select Selection.Characters(Start:=33, Length:=4).Font.ColorIndex = 3 This was very useful because, imagine a chart containing Temperature data...

This is not a VBA question. We switched to 2007 just last Summer (I know, don't ask). We have noticed that for files created in Excel2007, when the file is opened, it creates a temp file in the same directory with today's date and the original file is still shown separately with the original...

Hello, First post, long time lurker. I've found many answers to numerous questions over the years on this great site, but I finally have one I can't seem to find a solution for. I have 2 sheets in this work book. Sheet 1 is a form for receiving in material, and sheet 2 is layed out to print...

Hello all. :) I have a shared workbook saved on a network drive at my job. One of my ten columns contains a formula (the very uncomplicated WORKDAY formula.) After I fill new cells in the column with the formula and hit Save, I receive a Microsoft error message stating that Excel has...

Hello ... needing some help with a variable, I want to be able to have data copied to a TABLE to a specific row based on user input "Textbox1". So if the user enters "2" then the below data is copied to row 2 and if they enter "110" then the data is copied to row 110. <START CODE:>...

Hello I am trying to add several radio buttons. 3 groups of 3 ... grouped as follows: The worksheet is named "CoursesDB" that's where I would like the information to go to. combobox1 contains: fh1 - if checked need info going to (iRow, 42) ... value to = 1 or 0 ml1 - if checked need...