Recent content by CTKC

If you want to look for the last row with data in Column E, then paste your copied data one row below then just change E824 to E1. Sorry for the double post but I'm not sure how to edit

DrMingle, wsDest.Range("E824").End(xlDown).Offset(1, 0).PasteSpecial _ Paste:=xlPasteValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=True What this does is goes to range E824 then it looks down the column for the next cell with data. If there is not a cell with data below...

Skip - Thanks for your help once again.To be honest, I do not have to make a chart for each product, it's just the logic I used. I guess I could create a combobox and once the value is changed it would trigger the macro to get the corresponding data? Thanks again, Tom

Actually, I apologize... I had some error handling in there which is why I did not see the errors. I deleted out the error handling and I am getting Method of 'cells' of object_global failed once it hits the first seriescollection.values code...

Skip, I want to make a chart for each Product. Previously, i got the total amount of products in a variable (Total_IPT).Second loop runs down the rows to find the product name. Once it finds the product name what my attempt is anyway is to add a chart, input the source data for each series, the...

Skip, I recorded creating the chart. I did not include the titles.. I guess I could use the R1C1 notation but I would like to know what I am currently doing wrong... Tom Sheets.Add Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData...

Hi, Below is Part of my code. I am hoping someone can explain as to why the seriescollection.values do not work properly.An error does not occur but nothing is put into the source data. The series name code changes correctly.. Any help can be appreciated. Thanks! Current_Month =...

Do you have 2007? I am working on Excel 2003.

Skip, The code that I posted above works without putting a "=" in there. It also works if I include a "=" & .. Not sure why it works without a = though. [code] pt.calculatedfields.add "delta", "=" & pt.pivotfields(i).name & "-" & pt.pivotfields(i+1).name [/code That still gives an error...

Skip, With the code posted I was receiving this error: Run-time error '-2147024882: The formula you typed contains an error. etc,etc... After thinking about what I could be doing wrong and figured it out. It always seems to be something very trivial. The code below is correct and works...

Skip, I apologize if I am not explaining my situation well enough because it is hard to type what my data looks like. I do use real dates, such as 1/04/2009 Plan as a heading. I was just abbreviating in my message. I would upload a sample of my data but I know you do not like when people do...

The data is in an excel worksheet. THe first 14 columns are "standard" weekly fields but after that it depends on the weekending date.For example, right now, what I call my data file (just has a single tab with all the raw data), has 14 columns plus a column for each; 1/4 actuals, 1/4 plan, 1/11...

Basically I would like to create a calculated field based on certain pivotfields. I run a weekly report for each fiscal month with a plan and actual column. As weeks progress the source data grows. For example 1/4 Plan, 1/4 Actuals, 1/11 Plan, 11/Actuals, etc so the data source columns grow. The...

Skip, Thank you for your posts, it is much appreciated. You have helped me throughout each thread I have started. I have started to teach myself VBA for the past two or so months, how long did it take you to become proficient at it? Thanks, Tom

I understand it makes it more complex and complicated. But this is how we have to report our accounts. It's mandated by the Government and our Customer that we report to. We have to report on serveral criteria thats why we have multiple blocks of explanations. The current month output (that I...