D
dlaery
I export a list of items from Quickbooks.
Quickbooks will export as a xls file.
I want to create a different worksheet or workbook that will look u
data in this file. I need to find data in a certain column in a certai
row. So when my data changes in Quickbooks, I export the file, and the
in another workbook or worksheet, update, based on the new or update
data. I have tried the lookup wizard but it will not let me use
different worksheet or workbook. I can make it work in the sam
worksheet.
So what I'm looking for is a direction where to start. I have made man
complex Excel worksheets, using macros and formulas that I get fro
here. But I can't seem to figure out how to accomplish this one.
Thanks,
Davi
Quickbooks will export as a xls file.
I want to create a different worksheet or workbook that will look u
data in this file. I need to find data in a certain column in a certai
row. So when my data changes in Quickbooks, I export the file, and the
in another workbook or worksheet, update, based on the new or update
data. I have tried the lookup wizard but it will not let me use
different worksheet or workbook. I can make it work in the sam
worksheet.
So what I'm looking for is a direction where to start. I have made man
complex Excel worksheets, using macros and formulas that I get fro
here. But I can't seem to figure out how to accomplish this one.
Thanks,
Davi