Lookup Question

imasuitman

New Member
Joined
Dec 8, 2005
Messages
2
Here's the situation that I want to be able to automate via an excel or VBA function: I have workbook A with multiple worksheets; each worksheet lists the revenue checks to oil & gas owners that are written for a given month. In workbook B that is exported and downloaded daily from the bank are the previous day's cleared checks. I would like to mark the checks in workbook A that have cleared. Considerations: I would like to download new cleared check info every day without keeping the last day's so I'm not sure if that would be possible. I'm an intermediate excel user who would guess that I would try to do a lookup formula for this. What would be the easiest way, if possible to accomplish this? I could possibly consolidated multiple worksheets into one in Workbook A. Thanks in advance.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Where it me I would simply make my layout conducive to an autofilter.
For instance filter to anything recieved this month and with a clear date not null. Then Just select visible cells (alt-;) and paste into B. You can easily make this on into a macro too.
 

imasuitman

New Member
Joined
Dec 8, 2005
Messages
2
Thanks for the reply. But that's sort of what I'm doing now and manually marking them as cleared with an "X" next to them. But we send out several thousand checks every month, so I would like to have a formula or macro that would look at the bank download spreadsheet but not care when I deleted the bank download info afterwards since I don't want to keep both a listing of checks issued where I mark as cleared and the cleared check info for space reasons. My guess is that I would probably need to consolidate the multiple worksheets into one and just paste values after I run a vlookup and then have to rewrite the formula everyday since this is on a daily basis. Just to clarify, our company sends out these "revenue" checks to those having interests in the wells from which we purchase gas.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,131
Members
412,305
Latest member
Mozz
Top