-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
What would you do...
- Thread starter InTurn123
- Start date
Excel Facts
Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Yeah, learn VBA. If you get good enough you’ll be able to automate everything you do and your company won’t have to employ you any more. They will actually, they’ll keep you on the keep the macros working, just make sure you don’t get stuck where you are because you become irreplaceable.
I taught myself VBA when I had spare time at the end of the month. Got to the point when I had 1-1.5 weeks of work and the rest of the month with nothing to do. Not anymore mind you.
I taught myself VBA when I had spare time at the end of the month. Got to the point when I had 1-1.5 weeks of work and the rest of the month with nothing to do. Not anymore mind you.
yup yup.
If not you, someone else, so why not you?
I find the hard part is actually coming up with good ideas. If I got paid to sit around, I'd go crazy (been there, done that, still not sure I'm sane now though...)
After identifying something useful, I'd try to create it. Start my own business. What better way to do that than when someone else is paying for it???
If not you, someone else, so why not you?
I find the hard part is actually coming up with good ideas. If I got paid to sit around, I'd go crazy (been there, done that, still not sure I'm sane now though...)
After identifying something useful, I'd try to create it. Start my own business. What better way to do that than when someone else is paying for it???
How much?
How hard would it be to transfer invoices in SAP to an organized excel file, sort of creating a database? Sounds like a really good idea that would be beneficial for me and the company.
I'm guessing though, that this isn't so easy.
How hard would it be to transfer invoices in SAP to an organized excel file, sort of creating a database? Sounds like a really good idea that would be beneficial for me and the company.
I'm guessing though, that this isn't so easy.
SAP should be hooked into your accounting system. If this wasn't done, this was a major faux paux in the SAP implementation.
SAP is great for automated reports and data processing. Unfortunately when you get down to the details of data mining, often you have to manipulate the data and SAP isn't always the easiest thing to maneuver.
Thus lots of automated query data dumps into something that's much more maneuverable: access/excel.
This is exactly what the top consultants do when examining the operations of a company.
You might be pleasantly surprised how easy it can be to port a block of data into a text file and then get it into Excel/Access
SAP is great for automated reports and data processing. Unfortunately when you get down to the details of data mining, often you have to manipulate the data and SAP isn't always the easiest thing to maneuver.
Thus lots of automated query data dumps into something that's much more maneuverable: access/excel.
This is exactly what the top consultants do when examining the operations of a company.
You might be pleasantly surprised how easy it can be to port a block of data into a text file and then get it into Excel/Access
SAP to Excel automatically - Invoices
So I'm thinking of suggesting this to my boss, but I don't think I can actually do it myself. I'm not sure whether or not to tell him that this can be done because if I can't do it they'll have to pay some consultant person to do it right?
Does the value of not having employees backed up on invoices every now and then outweigh the cost of hiring someone to get the invoices to go from SAP to Excel automatically? I'm guessing it depends on the company so it's hard to say.
Any advice appreciated.
So I'm thinking of suggesting this to my boss, but I don't think I can actually do it myself. I'm not sure whether or not to tell him that this can be done because if I can't do it they'll have to pay some consultant person to do it right?
Does the value of not having employees backed up on invoices every now and then outweigh the cost of hiring someone to get the invoices to go from SAP to Excel automatically? I'm guessing it depends on the company so it's hard to say.
Any advice appreciated.
