Copying excel worksheet saving dropdown menus
Hi, Ive created a spreadsheet. I require 4 x spreadsheets and x 5 books. each sheet representing a week of the month and a book for each month until `December at least. When I've copied the worksheet the information in the dropdown menus haven't come across, although the formulas in different columns have. In the original workbook I had a second sheet within the book with the information to go into the drop down menus. Please can someone assist so I down have to keep creating dropdown menus and everything copies accordingly? TIA (its the log register
data validation
Hello Everyone, I am preparing an error log sheet, in that, I used a custom data validation in D column =AND($C$3<>1,$E$3<>1). just checking C column value is not equal to 1 and E column is not equal to 1 then it should allow entering in the D column. It is working properly if I used as a formula but allowing to enter the value when I used in data validation. Please help
Sommes de cellule conditionnelle
Bonjour, je dois réaliser un tableau de dotation de masques par agents (infirmiers, ASH ...) par jour avec un récapitulatif à la semaine. Je dois créer une colonne "NOM" avec un menu déroulant pour le choix des agents et une colonne à côté avec une insertion automatique = 0 si cellule vide ou = 2 s'il y a un nom. jusque là c'est bon. Mais je n'arrive pas à plus les cellules comportant le "o" ou le "2" vu que ceux qui ne sont pas des "montants". je n'arrive pas à trouver la logique excel. Merci de votre aide
copying multiple separated cells in one column and pasting into a new column
How can I copy multiple separated cells in one column (eg a1, a3, a11) and paste into a new column keeping the same distance apart (eg to c1, c3, c11). The basically pasted cells go to c1, c2, c3) ie. no vertical separation.
Conditional Formating in formula
I have a conditionall formula, that seems simple, but I can't get it written properly. Formatting has changed from the versions I have used before. I need help composing a "Sumif formula. Can somebody with the expertise call me, but e-mail me first, please. Attaching a short copy of the small data in Excel format.
