Pages

Search

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...

Excel Help Forum - Excel Programming / VBA / Macros: Input form data in a remote spreadsheet

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Input form data in a remote spreadsheet
Hey guys, So I have a problem with an Excell assignment. We have a spreadsheet with active deals and details for each of them on a shared partition on the server. I have to create a separate file, like a form (with data validation restrictions), which people can open, fill out the data,...

Excel Help Forum - Excel General: if contains forumela

Feed2Mail notification - new post on Excel Help Forum - Excel General
if contains forumela
I have cells which contact RQIA SP RIDDOR HSC TRUST SP / RQIA RIDDOR / RQIA RIDDOR / SP HSC TRUST / RQIA

Excel Help Forum - Excel Formulas & Functions: Averages and sequences

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Averages and sequences
Hi All, Hoping someone out there can help. I have the follow table of monthly Revenues for close to a 3 year period. I am trying to analyse monthly revenue increases. ie Sept 2012 minus Sept 2011 (this is the easy part) Number of issues: (a) if the series starts with a zero sequence...
Subscribe to: Posts (Atom)