Hi,
I have a database which shows members details with a colour system for varying levels of payment. I want to copy the membership number title and name from this d/base to another worksheet in the same w/book so I can print it in a4 size and select the page breaks. I think this is achieved by some thing called "concactia"??
The main use for Concatenate() is to combine data (text, numbers) from different cels into 1 cell.
For instance A1=Distancet and A2=3000
In A3 =CONCATENATE(A1,A2) would give you Distance3000
or to get more fancy...=CONCATENATE(A1," Equals "A2) would give you Distance Equals 3000 (Note the added spaces and text)
Not sure if this is what you want though? Perhaps upload a sample workbook, showing what you have a what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks