From Mike: Each work day, Mike gets a data set -from a database- and from that data set he needs to print a one page report for each record in the data set. Today, in Episode #1546, Bill begins the 'Print Form from Database' series with going over the data, how it is delivered and what the expectations for utilizing the data are. This is Part I or IV.
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel, MrExcel podcast, episode 1546, Print Form from a Database.
Hey, welcome back.
It’s Bill Jelen from MrExcel.
It’s time for another LearnExcel podcast.
This week, we’re going to be answering a question sent by Mike.
Mike has a database.
He gets this database every single day.
Someone sent some to this database.
And for every record in this database, he needs to print a one-page report, and send it out to the people and so Mike actually started in this way.
He had this database up here and he has in another section the printed report.
And so, he grabs the right field.
So, he doesn’t need all 13 fields.
He just needs specific things.
So, he needs some labels and he need it to look good.
I’m sure that Mike’s report looks a lot better than mine.
But, you see he has formulas here like =PROPER(E2)&”,”&UPPER(F2) to try and make things look good.
And so, print range down here like this, page layout, print area, set print area, clicked CTRL + P. And now, he has the record, how the report for the first customer.
But then, things went horribly wrong.
His first attempt is, “Okay, well, I need to have this data that’s currently in row 3 move up to row 2.” But, watch what happens if I delete row 2.
So, right click, and say, delete.
Alright.
And down here in my report, everything changes to reference errors because I just deleted this stuff that was pointing to row 2.
Alright.
And Mike called me up and said, “Hey, I’ve got a problem.
Which books do I buy to figure out how to make those formulas now point to the next row, row 3, instead of the current row?” Alright.
That’s the situation we have this week.
We’re going to look at different ways to solve this problem.
Thank you for stopping by.
See you next time for another netcast of MrExcel.
Learn Excel, MrExcel podcast, episode 1546, Print Form from a Database.
Hey, welcome back.
It’s Bill Jelen from MrExcel.
It’s time for another LearnExcel podcast.
This week, we’re going to be answering a question sent by Mike.
Mike has a database.
He gets this database every single day.
Someone sent some to this database.
And for every record in this database, he needs to print a one-page report, and send it out to the people and so Mike actually started in this way.
He had this database up here and he has in another section the printed report.
And so, he grabs the right field.
So, he doesn’t need all 13 fields.
He just needs specific things.
So, he needs some labels and he need it to look good.
I’m sure that Mike’s report looks a lot better than mine.
But, you see he has formulas here like =PROPER(E2)&”,”&UPPER(F2) to try and make things look good.
And so, print range down here like this, page layout, print area, set print area, clicked CTRL + P. And now, he has the record, how the report for the first customer.
But then, things went horribly wrong.
His first attempt is, “Okay, well, I need to have this data that’s currently in row 3 move up to row 2.” But, watch what happens if I delete row 2.
So, right click, and say, delete.
Alright.
And down here in my report, everything changes to reference errors because I just deleted this stuff that was pointing to row 2.
Alright.
And Mike called me up and said, “Hey, I’ve got a problem.
Which books do I buy to figure out how to make those formulas now point to the next row, row 3, instead of the current row?” Alright.
That’s the situation we have this week.
We’re going to look at different ways to solve this problem.
Thank you for stopping by.
See you next time for another netcast of MrExcel.
