Spaceballs_the_fanboy
New Member
- Joined
- Feb 15, 2018
- Messages
- 18
Hi. I have zero knowledge of excel VBA.
I am working on a project. From a seperate program i am able to export reports into an excel spreadsheet.
I want to copy and paste the spreadsheet into another excel workbook that has a Macro waiting to be used.
The report results are always the same number of columns, but the number of rows will always be dynamic.
I want a Macro run through a button to do the following.
Compare the results (which is a date) in column B (starting in row 5) to (the date) that is in C2.
I would like the results to be in column F.
The basic formula i have been using is:
=IF ($C $2>B5, "Over", "In")
Any help would be greatly appreciated.
I am working on a project. From a seperate program i am able to export reports into an excel spreadsheet.
I want to copy and paste the spreadsheet into another excel workbook that has a Macro waiting to be used.
The report results are always the same number of columns, but the number of rows will always be dynamic.
I want a Macro run through a button to do the following.
Compare the results (which is a date) in column B (starting in row 5) to (the date) that is in C2.
I would like the results to be in column F.
The basic formula i have been using is:
=IF ($C $2>B5, "Over", "In")
Any help would be greatly appreciated.