Pages

Search

Excel Help Forum - Excel Formulas & Functions: Keep copies of a sheet from linking to original sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Keep copies of a sheet from linking to original sheet
I would like to thank everyone for their help. I've learned a great deal from this forum while working on this project. I have two final problems PROBLEM 2 OF 2 The OCTOBER 2012 DATA ENTRY sheet is linked to the OCTOBER 2012 MONTHLY REPORT sheet. When I copy the sheets for the following...

Excel Help Forum - Excel Programming / VBA / Macros: VBA combinations

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA combinations
Can anyone help me with the vba to have excel take values I have given it (A1 to A250), Then give me 72 number unique combinations based off that data whose sum can't exceed 7750? I know it isn't using random number since that keeps duplicating.

Excel Help Forum - Excel General: Consolidate rows with duplicate ID number into one row

Feed2Mail notification - new post on Excel Help Forum - Excel General
Consolidate rows with duplicate ID number into one row
Hi everyone. I had a question that's been bugging me for a bit. If there are duplicates of an ID number in my database, how do I consolidate these into a single row and delete the duplicate? This is best illustrated in the example attached. What I have is on sheet one, what I need is on sheet 2....

Excel Help Forum - Excel Formulas & Functions: Max Date with Unique Name - Updated Request

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Max Date with Unique Name - Updated Request
"mike7952" and "alansidman" had provided an answer to my initial post regarding this but (good news/bad news) - they liked it so much, they said, "wow ... hey, then can you figure out how to do this ... ?" So I sat them down and narrowed down precisely (in their best world scenario) what they...

Excel Help Forum - Excel Programming / VBA / Macros: Archive anything older than 90 days and if actioned = Yes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Archive anything older than 90 days and if actioned = Yes
Hello, Was reading up on this and i'm thinking of merging but the i saw something about advanced filters and thought i'de turn to the boards! Attachment 188408 (http://www.excelforum.com/attachment.php?attachmentid=188408) What i was hoping was that automatically when "Response deadline...

Excel Help Forum - Excel General: creating a Pivot Table out of data in a cross-tab tableau

Feed2Mail notification - new post on Excel Help Forum - Excel General
creating a Pivot Table out of data in a cross-tab tableau
hi folks, i have a tableau of data in cross-tab format / layout. this layout is fixed because it is a data dump from another system. now, i need to generate a report on that data, for which i would like to utilise Pivot Tables. i have attached a sample excel workbook illustrating the as-is...

Excel Help Forum - Excel Charting & Pivots: Can I sort from columns in a PT other than just the first (left most)?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Can I sort from columns in a PT other than just the first (left most)?
Can I sort from columns in a PT other than just the first (left most)..and of course if so, how? Thanks
Subscribe to: Posts (Atom)