The discussions
How to convert date into words
SolvedHello, Hello i want to know how to convert date into words(english) for 05.05.1999 Thanks System Configuration: Windows Vista / Chrome 49.0...
Budgeting forumla in excel
Solved/ClosedHi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...
Copy rows n times in excel
SolvedHello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...
Vba to compare column e from 2 sheets and copy entire row to sheet 3
SolvedHello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...
Excel formula to track accrued vacation
SolvedHello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...
Copy rows based on a condition
SolvedHi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...
How to merge data from different excels
SolvedHello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...
Recalculation of dates
SolvedHello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...
Send to via access 2016 "wrong password"
SolvedI have a customer using Access 2016 with a custom database written by someone else. They were using IMAP but are now on 365. Since this move whe...
Explanation of formula used on conditional formatting
SolvedHi, Could someone please be able to fully explain how the following formula works with regards to conditional formatting? =AND(start_of_range""...
Populate separate worksheets with data from main worksheet based on criteria met
SolvedHello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...
Paste value on filtered cells
SolvedHello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...
Comparing two columns using partial match logic
Solved/ClosedI need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...
Copy rows to rows on another worksheet if " ✔ "
SolvedHi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...
Vba command button
SolvedHi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...
Count total quantity by date into month
SolvedHello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...
Saving multiple excel files based on a list
SolvedHi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my problem....
Powerpoint support for the lyrics on tablet
SolvedI am a singer and I would like to use my Surface tablet as a support for the lyrics. I can get it to work correctly, but only horizontal. I would lik...
Difference between delete and clear
SolvedCould some one explain both function ("Delete" and "Clear" in Excel) ?
If a column has a value add to another column?
SolvedHeya, i hope someone can help me with this. I currently have a very large formula sheet made up so i can input a value and add it too my total along w...
Copy and paste a record in same table - access/vba
SolvedHello, This might be more complex than the title suggests... I have a task tracker that records; tasks, date recorded, frequency (d,ww,m,q,yyyy...
Macro to copy / paste cell text down various rows
SolvedHello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...
Macro submit data drop to next row upon submission
SolvedHello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...
Recalculation
SolvedHi friends I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ...
Making my macro independent on future sheets
SolvedHello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I believe is...
Outlook syncing/sharing.
SolvedHi All, Do we have any Outlook gurus here? Something I've never had to do before, and dont know how to start - even google searches arent helpful a...
Making formulas work, which work on other computer
SolvedHello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and when ne...
Removing a 'false' result
SolvedHello, In the following formula, I am getting a 'FALSE' as opposed to a '0' result. =IF((F28+F31)
Multiple if statements in excel
SolvedHello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that it e...
Highlighting future dates
SolvedHi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...
Copy rows to other sheets based on value in column
SolvedHello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...
Make userform
Solved/ClosedHello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...
Vba code for copy & paste items for multiple times
SolvedHi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...
Create sheets for additions to list on sheet one.
SolvedI have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...
Overwriting data during transfer
SolvedSir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...
Vba code for command button
Solved/Closedhello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...
How can i separate each slides from one ppt file?
SolvedHi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to create ...
When the field is =n, want to subtract that field
SolvedHello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...
Conditional formatting across multiple columns
SolvedHi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...
Copy conditional formatting for an entire row based on one cell
Solved/ClosedHello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in t...
Duplicate rows from multiple worksheets
SolvedHello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to perfor...
Excel "if" function w/ date in test cell
Solved/ClosedHello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...
Change color for specific number of cells by value
SolvedI have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...
Auto populate from master file to other
SolvedHi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...
Auto create info sheets from master spreadsheet
SolvedUPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My remaini...
Microsft word icon is gone.
Solved/ClosedHello, I have a question. Until recently there has been a Micorosft icon on my desktop and it showed up under the "All Programs" list on my Start ...
Convert pdf to word without altering pdf images
Solved/ClosedCan converting from PDF to word be done without alterations of the PDF images?
Use in scripting.dictionary- item join string 3col
SolvedHello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of-the-sa...
How to change date format from yyyymmdd to mm/dd/yy in excel?
Solved/ClosedHello, I have data with dates arranged in yyyymmdd format. Is there an easy way to change the format to mm/dd/yy in Excel 2010? Thanks!
How can i automatically copy table to next sheet?
SolvedHello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once a d...
