VBA code to create a compiler.

levantkaien

New Member
Joined
Jun 15, 2012
Messages
10
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...
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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

New Member
Joined
Jun 15, 2012
Messages
10
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,810
Messages
5,638,483
Members
417,027
Latest member
wlknspc7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top