Need advice and direction on a project

[NetEcho]

Good day,

I'm fairly new to the Excel VBA programming world and am looking for some direction on a function I need to build. I do however have some experience with Visual Basic.

This is what I'm trying to develop;

I have 2 report files, both files display the same information just organized differently (one is for less technical people and the other for technical use)

File 1: Is laid out with a tab for each day of the month I.e. Jan 01 is Day 01 etc.
where as the second report is a separate file for each day.

I'm trying to make it so the second file can automatically put number ranges into the first file based on Date. I.e.


Report #2 has 3 fields Number 1 , Number 2 and Number 3 which corespond to Range 1 on Report #1

What I want to do is after you have entered those 3 numbers to be able to click a button and have Excel take the total of those ranges
and input them into Range 1 on Report #1 based on the date field on Report #2

Something like

Cell B1 = A1+A2+A3

}
[Copy Report2.xls!CellB1]
[Open Report1.xls]
[Paste CellB1 in Cell F4]
[Close Report1.xls]
}

I would also like to make this scalable to fill in multiple ranges

I'm not sure how to elaborate on this more right now but any guidance is much appreciated

Thanks!

[royUK]

I'm not really sure if you need VBA for this. You need to attach dummy files

[NetEcho]

Can you please elaborate on what you mean by this?

[royUK]

Not without the requested example workbook

[arlu1201]

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[NetEcho]

Not without the requested example workbook

Ok since my spreadsheets are nowhere near complete I decided to use some spreadsheets from a previous employer that actually spawned my curiosity to see if excel can do this.

On the Income Journal under the GL tab a lot of those cells get added together to create summarized cells under the corresponding day in 01 Jan.xlsm and the two reports are basically the same data just Income Journal is a more itemized version

so as a basic example Income Journal GL!D20 - D28 get summed up and placed under the Corresponding Day Tab on 01 Jan.xlsm under C43.

I would like to be able to use what I learn here across a variety of projects such as personal budgeting spreadsheets that help me better come tax season and maybe some class projects next year if I can fully understand the code.

Let me know if you require any more information


EDIT:

Ok with some reading I think I have the start of some code to help guide this advice

First of all I created 2 hidden sells on the Income Journal File F22 and F24

GL!F22 is a sum of all the "Misc" Revenue lines and GL!F24 is =NOW() formated as just "D" so it displays only the day numbers

the code I've started with is

Please Login or Register  to view this content.

Now one inherent problem I'm having is such; On the cover page they enter the date as dd/mm/yyyy , I need to create a variable that can pull just the day number out of there so I can make this work.

I.e. 21/04/2012 I would need the variable to equal 21 so that I can do Sheet(21).Select

so to summarize on this (sorry for my abstactness) Say they enter in Cell D24 on Sheet1 04/21/2012 I need 3 variables
Month = 04
Day = 21
and Year = 2012 . Aside from that my code for the most part seems to be working, just needs some cleaning up