VBA store references with arrays

**fuatt** · 01-24-2013, 11:28 PM

Hello everyone,

I am a beginner with VBA and this is my first post here, so I want to start off by saying thanks for this great source.

Here is my issue:

- In my "output" workbook I have 2 sheets: "database" and "report"
- In the first column of database I have my reference numbers, and other columns contain some data-info.
- In the report sheet, again in the first column I have my reference number and according to these ref numbers I have some formulas in other cells.
- Here comes the question, How can I pass some data from two cells in my database to one cell in my report sheet by using the reference numbers? The formats of the texts(font color, size) in the database sheet should be kept when transferring to report sheet.

I hope I could have explained well and you may want to see the attachment to understand better.

Thanks in advance for your help!

The same question here:

http://www.mrexcel.com/forum/excel-q...ml#post3374850

**patel45** · 01-25-2013, 03:31 AM

symply concatenating your formulas with operator & , see attachment

**fuatt** · 01-25-2013, 04:39 AM

Thanks patel45 for your answer.

What I want to do this using VBA, and probably arrays will do what I need.
Why? Because I want to have not only values but also same font sizes and colors...etc. As far as I know formulas cannot do this(?).

Whenever I enter the reference number into the cell below reference cell I will have the inputs from the database sheet.

In the printout sheet of my file you can see what I exactly want to have there.

**Kyle123** · 01-25-2013, 07:15 AM

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).