VBA code to create a compiler.

[levantkaien]

Hi,

I'm having difficulties in creating a VBA code to compile entries that is entered on a report I have. The report has a Macro to auto send a selection on the file once it is filled out. I need to have the entries compiled on a "summary" file for reporting. Please help, I'm not very used to VBA yet...

 

[hiker95]

levantkaien,

What version of Excel are you using?

Can you post the raw data, and, post the results you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.


If you are not able to give us screenshots:
You can upload your workbook to Box Net,

sensitive data scrubbed/removed/changed

mark the workbook for sharing
and provide us with a link to your workbook.

 

[levantkaien]

Hi hiker95,

I'm using Excel 2007, what I would want is to have a button on a file, once I enter details on it, it will auto compile the details on a specific workbook. I have a template that auto sends notifications made on excel,although I need those notifications compiled..not sure if it makes sense...

 

[hiker95]

levantkaien,

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.