[ExcelVBA] Re: Combining cell results in different worksheets

 

Oh, I hope those images are good ones! Will explain in next post.

I have the concationate figured out and I also reworked the cells so that when they are combined I get the formating I can live with. However, I'm getting some extra data that I don't know where it is coming from.

It will be a task to track it down as there are 15 sheets and almost 700 cells in each sheet. For the sake of simplicity I need to look at cell 1 on each of the 15 sheets and concationate those 15 into cell 1 on the "summary sheet". Then cell 2 on each 15 sheets and concationate them to cell 2 on the "summary sheet", etc,etc..

I've entered the concationate formula into the first two cells of the "summary sheet" and dragged it to copy into all the other cells. All of the formulas in the individual cells look correct. I only need to look at 400 cells on each individual worksheet so there are only that many concationate formulas in the 'summary sheet'. I'm just starting to teach myself Excel to there is a lot of trial and error.

I appreciate the time, comments and help you have offered.
Thank you... Gene

--- In ExcelVBA@yahoogroups.com, "david braithwaite" <dbraithwaite@...> wrote:
>
> Hi multiuseguy (would you explain this moniker.it brings many images)
>
>
>
> Observation:
>
> If you get result you desire, you will lose the ability to know which sheets
> the data comes from.
>
>
>
> Suggestion:
>
> You can do this with a really complicated CONCATIONATE state which still may
> be preferable to using VBA since you only have to do it once.
>
>
>
> Concatonate (if (trim('t 1'!c7)="",'t 1'!c7 ,""), if (trim('t 2'!c7)="",'t
> 2'!c7 ,""),..., if (trim('t 15'!c7)="",'t 15'!c7 ,""))
>
>
>
> You don't even need the "trim" function since you could compare for " "
> which you say each non-value cell contains.
>
> But this way... you don't have to force a space into these cells, but can
> also handle blank cells (or even cells with just multiple blanks)
>
>
>
> Db
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___