Search results

I'd appreciate any help for this. I want to post the data from one cell on a worksheet to a new column on a worksheet. The tricky part is, the data needs to be posted on a specific row based on 2 criteria (year and quarter). Example: Worksheet 1 - Has the criteria and data to be posted...

I successfully use SUMIFS formula to with INDEX(MATCH) to return a result from a specific worksheet that matches the multiple criteria in the formula. I just tried to pull in a result that is a text value and not numerical. It returns a "0". I have formatted the cells using different...

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...

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...

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...

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...

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...

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...

Hi...I'm new to the site, but have enjoyed reading through the forums and trying to some of the problems and examples on my own. I would classify myself as a beginner/intermediate excel user. The next big step I'm working on is trying to learn array formulas. Anyways, here's my question to...