Pages

Search

Excel Help Forum - Excel General: VLookup Syntax required to look up period date if I put 'Yes' in a cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
VLookup Syntax required to look up period date if I put 'Yes' in a cell
Hi, could anyone please advise me of the Vlookup syntax to look up the current period dates from a range of period dates if I put 'Yes' in a cell? What I have is a workbook with two worksheets i.e. 'This Period' and 'Admin'. The 'Admin' tab has this finacial years dates in columns C & D...

Excel Help Forum - Excel Formulas & Functions: Counting number of times a word appears across worksheets

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Counting number of times a word appears across worksheets
Hi , Basically I have created a spreadsheet with details of several different people for HR purposes. Each person is assigned to a worksheet called 'People Info' and I have 70 copies of that worksheet with each persons details on. One of the criteria is each persons work status which has a drop...

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)...
Subscribe to: Posts (Atom)