macro to create a pivot table
I have seen some answers to this question, but my problem is so simple that I
can't seem to make it work. :-) I have a sheet with about ten columns of data. I need to create a pivot table with Salesrep as the row field and Grossamount as the data field. I want to save this pivot table to a sheet called AcqPivot in the same workbook (AcqReport) and rewrite the old table. It's so simple that I wouldn't even bother with a macro if I didn't have to do this several times a day. I've tried several approaches, many from this site, all with different errors. I believe I am making this too complicated. I tried recording, no dice, I tried some code samples, but I can't seem to make it simple enough without breaking something. I'm on Excel 2003. Any suggestions for sites with reliable code suggestions, examples, or tips would be very much appreciated. |
macro to create a pivot table
Give us some idea about your data. Are they in consecutive columns? Any
gaps in the headers at all. Does it start from A1 and go across, eg B1, C1 etc. What about number of rows - is it consistent or does it vary. If it varies, do you have one of those fields that you can rely on to hold data in every single record, eg if your data was in say A1:K100, could you say perhaps that every record would have a value in Col C or D etc etc. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Catie79" wrote in message ... I have seen some answers to this question, but my problem is so simple that I can't seem to make it work. :-) I have a sheet with about ten columns of data. I need to create a pivot table with Salesrep as the row field and Grossamount as the data field. I want to save this pivot table to a sheet called AcqPivot in the same workbook (AcqReport) and rewrite the old table. It's so simple that I wouldn't even bother with a macro if I didn't have to do this several times a day. I've tried several approaches, many from this site, all with different errors. I believe I am making this too complicated. I tried recording, no dice, I tried some code samples, but I can't seem to make it simple enough without breaking something. I'm on Excel 2003. Any suggestions for sites with reliable code suggestions, examples, or tips would be very much appreciated. |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com