Using a Macro that is tethered to two separate spreadsheets?

[ksumali]

Hi all,


I have been thinking and well, I get repetitive data often and I have to keep my supervisors updated with data on a daily basis and well to be honest it gets quite repetitive. So I find myself doing the time task multiple times and instead of being able to progress, I find myself in constant retreat; as I have to go back and repeat a process I have already done time and time again before.


Basically,

Mon (tons of new work, time consuming, but this is the main chunk of my work)
Tue (not much change in data/ could possibly be made very simple with macro)
Wed (not much change in data/ could possibly be made very simple with macro)
Thu (not much change in data/ could possibly be made very simple with macro)
Fri (not much change in data/ could possibly be made very simple with macro)

I get my data and I have to assign it a category.

item X (not assigned)

{after Monday work}
item defined as A
thus item A is defined with a color to show classification.

PROBLEM POINT**

Tue
Wed
Thu
Fri

I am repeating Monday 4 more times in a week.

Well why can't I just use the same Monday data and just rename it Tuesday?

Well, that is because we get more items during the week, though low in number, do have to be accounted for.

So, to my question.

Can I have a macro pull this 'repeat' data from another file that contains the same name?

It sounds dangerous and a pipe dream, so send troops!


Caleb
Macro Recruit

 

[Redders]

Can't you just do a simple vlookup on the data, output what you've already done and 8dentify what you haven't dealt with yet?

 

[ksumali]

@Redders

Sorry for the late response. Found some more free time at work to get technical with the macros again. I am a beginner go easy! haha
I will take a look into the VLOOKUP. There are all these functions I never knew about. I only know CTRL + F.

Let me run a test on VLOOKUP and see if I get some results.

Thanks for the prompt reply; and sorry again for the tardiness.

Caleb
Excel/ VBA Recruit