348 reputation
14
bio website spreadsheetsmadeeasy.com
location Florida
age
visits member for 2 years, 8 months
seen yesterday

Jun
1
awarded  Nice Answer
Jul
31
comment Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes
I think I'm thinking the same as @CharlieRB. Have you tried saving the file as xlsm / xlsx? There might be some info from the 2003 version that isn't being understood correctly for Excel 2010. Saving it as the new file type might correct that.
Apr
7
awarded  Yearling
Mar
14
comment How to change default text color in MS Excel
You can use the Track Changes feature if you like. Go to the Review tab, hover over the Track Changes button (it is probably disabled) and when you hover over it, a pop-up will show up and say Press F1 for more details. Press F1 there is a whole article in the help files on how to activate and use it.
Feb
1
answered Lookup minimum value per month
Dec
31
answered How do I create block diagrams in Microsoft Office without using Visio?
Dec
31
answered Ignore multiple “number stored as text” errors at once
Dec
10
awarded  Editor
Dec
10
revised How to input date range in word for SQL query?
formatted code
Dec
10
suggested approved edit on How to input date range in word for SQL query?
Dec
10
comment How do I copy part of an Excel worksheet to another Excel spreadsheet and retain the formulas rather than just the figures in the cells?
@Bruce, I'm not exactly sure why it doesn't work when you have two instances. It might have something to do with the fact that MS Office has their own Clipboard and I guess when you try to paste to another application instance, it has to use the Windows clipboard? either way, I'm glad it's working now for you!
Dec
10
answered How do I copy part of an Excel worksheet to another Excel spreadsheet and retain the formulas rather than just the figures in the cells?
Dec
9
comment Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)
you're very welcome! If you have any questions about adding conditions or how the code works please let me know.
Dec
8
answered Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)
Dec
8
comment Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)
ok. is it safe to say you can completely ignore any row with N for the value column?
Dec
7
comment How to Add one column based on the values of another column AND display into another sheet
Glad you got it working :)
Dec
7
answered How to Add one column based on the values of another column AND display into another sheet
Dec
7
comment Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)
where does your data come from? a database?
Dec
7
comment Special-Pasting a hyperlink in Excel
Is the hyperlink from the function =Hyperlink() ?? Also, I don't get the reason why you would want to do this. Is there extra formatting that you don't want to come with it?
Dec
7
awarded  Teacher