Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: numbers with `comma style` in text format

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
numbers with `comma style` in text format
Hi all, I`ve got a database, in which few columns are filled by the numbers in general, accounting or custom format, but for all of them `comma style` has been applied. So they look like this: 32.200,00 119.850,00 38.608,00 11.970,00 11.970,00

Excel Help Forum - Excel General: Automatic enter

Feed2Mail notification - new post on Excel Help Forum - Excel General
Automatic enter
Hi Forum, You've helped me out before with this, but this time its a bit more complicated and I need expert advice. I'm looking to have excel automatically enter to the next line - but only after it has went to column A and B and then enter. I'm looking to use a barcode scanner to scan...

Excel IT Pro Discussions Forum: Microsoft Office 2010 External Data Link Reference Issues

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Microsoft Office 2010 External Data Link Reference Issues

We have upgraded Microsoft Office 2003 to Office 2010 Professional in our premises. Mostly in Excel 2010, users are getting issues with update in external link references, like link references are getting changed or not getting updated most of the time and also files are taking longer to get opened. 

Most of the desktops having this issue, running on windows 7 professional 64-bit with Office 2010 Professional 32-bit version. 

Whether this can be reason? Or it is necessary to keep 64 bit version of Office with 64-bit Operating System?

Kindly adv. 


Excel Help Forum - Excel Formulas & Functions: Macro to find text and if found, copy an adjacent cell into a different cell

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Macro to find text and if found, copy an adjacent cell into a different cell
Hi All, I have been trying to alter various macros for a current problem I am having and so far I have been completely unsuccessful. I require a macro that will look for certain text in a column and then if it finds the text, copy the contents of an adjacent cell into a different cell. So the...

Excel Help Forum - Excel Programming / VBA / Macros: Refresh listbox when list is changed via listbox_click event

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Refresh listbox when list is changed via listbox_click event
Refreshing a list box with Excel 2012 Mac I have 2 list boxes on a userform. lb1 & lb2 (both multicolm and linked to ranges on different sheets) When I click on a selection in listbox1(lbshowdata) it will move the selection over to listbox2 (lbEditData) and delete the selection in sheet(range)...

Excel Help Forum - Excel General: Filename based on value of cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
Filename based on value of cell
Hi Im making an invoice template and I want to make it really nice and easy for the people that are going to use it. I have a cell with the 'invoice nr' lets say A1 which would have the value 859 I want that everytime someone hits 'save as' the suggested name is 'invoice 859.xlsx' I...

Excel Help Forum - Excel Formulas & Functions: Naming a sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Naming a sheet
Hi: How can I name the sheets in a file with the content of a particular cell on every sheet. For example, cell A2 of every sheet contains the name of a person in the team. How can I automatically name each sheet with the particular name in cell A2? Sheet 1 has John in cell A2 Sheet 2 has...
Subscribe to: Posts (Atom)