Search results

Question can this be edited to be used to auto populate rows in a report? I was looking around for an option that would allow me to auto populate a new row each time it is needed. I have a report that is feed by other sources and as the other sources data expands the report must expand to...

FYI!!! All your options are great! I really appreciate all the hard work that has gone into helping to find a solution!!! I just need to know how to apply, where to apply and what changes I need to plug in so I can apply this to as a solution. Humor me please I function in Super Tiny Baby Steps...

How so since I am super green, like fish out of water... In respect to the wks1 cell M21(Total Value) and wks2 cell E32 (Total Value linked) to wks2 cell E31 (where I need the prior total value to populate)... How do I input that into the VBA coding and into my speadsheet? As well there are...

This is a goofy question but since I am very new to this can you explain how the Accounts_Table,2,FALSE is used... I see Accounts_Table and it lists alot of descriptions...Column one and column two of the table are not always the same???... What does column one represent and what does column...

Let me explain the setup. I have 2 worksheets in a work book. (worksheet 1=wks1) master report, (worksheet 2=wks2) graphic/chart/pie display. The (wks2) data is updated from the wks1 cell M21. M21 is stable it just represents the total dollar amount and as the report data is updated with new...

Sounds good... I was going to ask whom ever responded to provide details. KISS... :) I couldn't find my way out of a paper bag at this point let alone create a vba... ;) got anything simpler? Thanks

I have a master report and it pulls from various sources. When it updates it will of course change the total value. I need my report to automatically capture what the prior value was and place it into a prior total value cell right next to the updated new value. (I have this set-up on a...

Bless You!

Any such luck? I know it's shorter days due to the holiday months... Any assistance is greatly appreciated!

I have looked it over and it's a very elaborate piece of work... Most impressive!!! Just clarify thatall of the cells to the right of the Value Populate column are the formulas that will need to be added on the report each day a new report is genarated so I may extracting the proper data I am...

May be I am not making any sense…I did provide an example: Tracking Report: https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!113&parid=8C4598BED3EF132A!108&authkey=!AJ7yC0bayODTBZk As you suggested I added the Conversion formula (text to numbers)...

Please humor me Where would I place the formula in the report? The last blank column on the far right of the reported data?

I guess this is a dead unsolvable issue?

Could a filter macro work in this situation?

Oh, sorry thank you for your idea but, I don't even understand "you'll probably need to setup an XL query to look at a "table" in another workbook and then return sum values based on parameters (A1:A3). You could be speaking Ubbi Dubbi's from Zoom back in the day...See the challenges I face...LOL

Could I use a filter macro on my data... I found this example but, I dont' know what I should change to make it work for my data pull... I need it to search the data report and capture Column B1-B3...etc... (* general office supplies or * apparel or * training) and then provide Column C dollar...

Good Day... Does anyone have any suggestions on how to accomplish this in a simplistic way? I am tring to reduce the steps to take to generate a daily report...Thank You in advance for any guidance!

As well I was just looking at the Source data for the column (C1-C3) dollar amount and it is listed as custom for the text type. instead of numbers.. does this need to be converted to numerical first? can this be worked into the formula?

Generated daily in excel format... Source Report: Column B1-B3 (* general office supplies or * apparel or * training) Source Report: Column C1-C3 (provides the dollar amount spent) The Main report is in excel format... Main Report: Column A1-A3 = Defined Name (general office supplies or...

The end goal here is that the dollar value is generated if matching the criteria, which will be linked to a final report... So, it's not really an easy fix to extract the information I need to populate in a specific cell in a final report. Rats... What happend to good ole ODBC abilities...

Nice!!!!... now what formulas do I put where? exactly as you have it on the worksheet?

Thank you for your time and guidance. I really appreciate your help.

I have created a conversion column and changed the characters to numerical value. Works Beautifully!!!! Then I have entered into the very next column the formula suggested that searches for the particular description and should return the dollar amount associated with the descrition which...

The Tracking report you have reviewed is an autogenerated report which will not be altered... That why I was just sifting through and pulling the info automatically... I am not able not supposed to be changing any of the format. Just pulling the correct data and obtaining a total value...

THANK YOU!!!