Search results

hmm..guess not..this posted right away. maybe it was posting links referencing other forum topics on chandoo? not sure...anyways, I removed the links and reposted and it worked.

are posts being modded? I tried to post..thought my browser locked up. re-typed same post...still nothing. thought it might be chrome web browser, so I re-typed and posted again in internet explorer. still no post. i've posted before...did something change? thanks, -maku

I am coming to the end of a long project I have working now. It is an excel database of 80 plus housing properties. Each one of the 80 plus housing properties has it's own worksheet tab. In addition there are worksheet tabs with pivot tables, pivot charts and a report card summary sheet. I...

Luke...thanks for the idea...it sort of worked. it did pick up the rows after the blank rows, but it also picked up the blank rows, or rows that had a blank value in the YEAR (Q2) cell. I guess it's better to pickup the blank rows, than to skip all the rows.

I have a VBA script I use to consolidate data from multiple tabs in my workbook. Each tab has identical columns of data headers. The YEAR data header starts on column "Q". I thought the VBA script was working great, but noticed a flaw. I want to have it set that if I type a value in the row...

That's a downer. I'm glad I found the grouping option. I'm hoping to develop this further with Running YTD totals with Charts in the future. I may have to use a standard chart and not pivot chart. THanks Narayan!

No worries...family and friends are more important than excel formulas :) I have other things to work on and can modify this when/if the answer comes forth.

I found I could group months on the pivot table and name that my quarter [ http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/ ] But, when I do this, if I unselect my data entry 1st Qtr in the pivot table/chart and just leave my group 1 showing which shows (Jan Feb Mar) I...

Narayan- Thank you...your formula worked to change the data formatting! I couldn't figure out how to get that to change...I'm amazed at the knowledge on these forums. Regarding your comments, I think the structure is opposite of what you are thinking in your comment #1. The data in the tabs...

Here are instructions for posting a file...they are in the sticky's at the top :) http://chandoo.org/forums/topic/posting-a-sample-workbook

Hui...thank you for offering to take a look. The workbook is still a work in progress, so not all is functional, but most is. The pivot charts on the "Report Card" worksheet (ws) are located in the PivotTable ws. THe PivotTable data comes from the MasterData ws. The instruction page tells...

SirJB7, the array formula is complements of Luke I believe...or another ninja's post that I adapted. you're right, I should have deleted the named ranges...those copied over from my workbook that I previously copied...they don't apply to this workbook. I didn't name any ranges in this example...

Most of the ninjas will probably laugh at the complicated setup, but I have to start somewhere...I'm learning. :) btw, I just noticed your title is Visual Basic. I did this all in excel formulas...no VB, not sure if that will work for you.

arcplus, welcome to chandoo. I've learned so much from reading posts and the help of others on here. I had something similar to what you are looking for I think in one of my recent projects. Take a look a let me know. I'm sure there are many ways to do this, probably better ones, but...

Does excel have a limitation to show dates format if data column has mixed entries? I have a pivot table and chart that has months listed. (year is a separate column). I've tried every way I can think to format the months column (text, date, general, etc) to get the end result on the pivot...

SirJB7, I thought it was PasteSpecial that was needed, but didn't know how to separate the syntax out. Thank you! Your code didn't quite work, it created a Run-Timer error '1004' Select Method of Range Class Failed. I altered your code adjustment a little, and it works as desired...

I've pieced together a macro that goes through all my worksheets and pastes data from worksheets that contain data tables to a Master Data worksheet. The problem is, I have formulas in some of the data table on the individual worksheets, but don't want the formula copied from that worksheet to...

Worked beautifully Luke...I would have never been able to do that by myself...I need to teach myself VB..although I can follow along your code very easily. Thank you for your assistance, I appreciate it! You are a ninja! -Maku

I've searched the forums and can't find the solution to my problem, though it may be there in a combination of multiple problems. I have multiple worksheets in my workbook. Some of the worksheets are summary pages, data parameter pages with helper cells (etc), but most worksheets have the...

You guys are geniuses! Thank you so much. Hopefully my question will help someone else too! Here's the end formula I used that worked...

Thank you Luke and Sajan...that's gives me a good direction...I'll work with those examples you gave me and see if I can get it to work. I see if I can use the named range it will really clean the formula up too. Thanks! I'll let you know if I get it :)

@sthomas- I'm not sure that will work, because I need to constrain the data being retrieved by multiple constraints. In my example, I am pulling Column O [which is labeled debt]. But, the "debt" changes and has multiple line entries for different years, months, and quarters. So, on the SUMIFS...

sorry, I didn't post the remainder of the formula with the constraints. Here it is: =SUMIFS('Meadowview Estates'!O:O,'Meadowview Estates'!L:L,parameters2!$C$4,'Meadowview Estates'!K:K,'Summary Data (2)'!$B$1) Column O:O is the data I'm retrieving. And in the above formula, if I change...

There is a post in the forums that sort of addresses what my question is, http://chandoo.org/forums/topic/lookups-referencing-tab-names but I'm not sure if I should ask in that thread my question or ask separately. There is a formula that is given that kind of works with my file, but the...

Thank you for your tips..I'm working on restructuring my file...it's challenging...but fun! Thanks for you help! -Maku