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!
Bookmarks