Since buying a 27" Mac with a 3.4GHz Intel Core I7 processor with 8GB 1333MHz DDR3 SDRAM and a 2TB Serial ATA Drive being backed up with the 2TB Time Machine something or another, I think I've been getting along relatively well. I've had to purchase some new software I hadn't planned on such as the latest version of Office for Mac, Quickbooks for Mac and OmniPro X. I seem to have the networking part down (my downfall with my MacBook Pro a year or so ago) but am having a real devil of a time with Excel.
I'm told that Excel is Excel; whether it's on a Mac or a PC and I just need to know Excel. Well, I know Excel to the point where I created the programs I needed for keeping track of customers and doing payroll (read; the most important issue - payroll - must be done tomorrow). I get my entire agency data downloaded to me by a company and I have to slice and dice and sort out who, out of just 9 people now, get paid what on which producers. The good thing is that my program still does that for me on my Mac. The bad, really, really, really, really bad thing is that I seem to be unable to move and delete columns like I used to be. Now it won't allow me to move columns because it says they are "merged" with other cells or columns or something. Humph! It never did that before and the company says they haven't changed anything.
I easily found the little place in the toolbar where I could mark "un-merge" cells. Yeah, problem solved!......not! That turns my entire worksheet into gibberish that does me no good. Do any of you smart guys know why this is now happening to me? The company who sends me the data tried to help, but basically said they are sending me the same thing they've sent me for the last 15 years and it must be moving from Microsoft Office 2004 (I think) to Microsoft 2011 for Mac that is causing the problem.
So, if anyone could possibly explain to me why my data goes to gibberish when I un-merge it and how I can prevent such, it would make my life so much better! My employees are the type that just may want to burn my home down if they don't get paid on time. (Not really, but I do pride myself in paying on time every time). There you have it. I need to move complete columns of data and just delete other columns of data really. The rest of the stuff seems to work with my formulas I created 12 years ago. I typed in about 10 lines of the 1251 lines in the sheet and my little program worked like a champ and paid the right person the right percentage each time. You see, sometimes an account is split between up to 3 different people and the percentage each person earns varies greatly depending on other factors that really aren't important now. That part of my formula appears to work just fine. I just can't figure out how to get past this merge/un-merge thing and move my data to the places I need it.
Many, many thanks and rep points will be gladly sent out for any and all who even attempt to help with my dilemma. Oh, for what it's worth, after forcing me to only use the iMac for 3 weeks, I think I can get used to it and like it.
I'm told that Excel is Excel; whether it's on a Mac or a PC and I just need to know Excel. Well, I know Excel to the point where I created the programs I needed for keeping track of customers and doing payroll (read; the most important issue - payroll - must be done tomorrow). I get my entire agency data downloaded to me by a company and I have to slice and dice and sort out who, out of just 9 people now, get paid what on which producers. The good thing is that my program still does that for me on my Mac. The bad, really, really, really, really bad thing is that I seem to be unable to move and delete columns like I used to be. Now it won't allow me to move columns because it says they are "merged" with other cells or columns or something. Humph! It never did that before and the company says they haven't changed anything.
I easily found the little place in the toolbar where I could mark "un-merge" cells. Yeah, problem solved!......not! That turns my entire worksheet into gibberish that does me no good. Do any of you smart guys know why this is now happening to me? The company who sends me the data tried to help, but basically said they are sending me the same thing they've sent me for the last 15 years and it must be moving from Microsoft Office 2004 (I think) to Microsoft 2011 for Mac that is causing the problem.
So, if anyone could possibly explain to me why my data goes to gibberish when I un-merge it and how I can prevent such, it would make my life so much better! My employees are the type that just may want to burn my home down if they don't get paid on time. (Not really, but I do pride myself in paying on time every time). There you have it. I need to move complete columns of data and just delete other columns of data really. The rest of the stuff seems to work with my formulas I created 12 years ago. I typed in about 10 lines of the 1251 lines in the sheet and my little program worked like a champ and paid the right person the right percentage each time. You see, sometimes an account is split between up to 3 different people and the percentage each person earns varies greatly depending on other factors that really aren't important now. That part of my formula appears to work just fine. I just can't figure out how to get past this merge/un-merge thing and move my data to the places I need it.
Many, many thanks and rep points will be gladly sent out for any and all who even attempt to help with my dilemma. Oh, for what it's worth, after forcing me to only use the iMac for 3 weeks, I think I can get used to it and like it.