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!