Forum
Office Software
- Solved
-
Copy rows n times in Excel [Solved]
Hello, 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...
-
If cell = date return yes or no. [Solved/Closed]
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes,...
-
VBA to compare column E from 2 sheets and copy entire row to sheet 3 [Solved]
Hello, 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...
-
Excel formula to track accrued vacation [Solved]
Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they...
-
Copy rows based on a condition [Solved/Closed]
Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
How to merge data from different Excels [Solved]
Hello, 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...
-
Recalculation of dates [Solved]
Hello, 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...
-
Send to via Access 2016 "wrong password" [Solved]
I 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...
-
Explanation of formula used on conditional formatting [Solved]
Hi, Could someone please be able to fully explain how the following formula works with regards to conditional...
-
Populate separate worksheets with data from main worksheet based on criteria met [Solved]
Hello, 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...
-
Paste value on filtered cells [Solved]
Hello, 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...
-
Formula I should use [Solved/Closed]
I am so confused on what formula should i be using for my work...? Which should be ending up like this...
-
Comparing two columns using partial match logic [Solved/Closed]
I 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 " ✔ " [Solved]
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago...
-
VBA command button [Solved]
Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and...
-
Count total quantity by date into month [Solved]
Hello, 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...
-
Saving multiple Excel files based on a list [Solved]
Hi, 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...
-
Powerpoint support for the lyrics on tablet [Solved]
I 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...
-
Difference between delete and clear [Solved]
Could some one explain both function ("Delete" and "Clear" in Excel) ?
-
If a column has a value add to another column? [Solved]
Heya, 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...
-
Copy and paste a record in same table - Access/VBA [Solved]
Hello, This might be more complex than the title suggests... I have a task tracker that records; tasks, date recorded, frequency...
-
Adding days to a date based on drop down menu [Solved/Closed]
Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year) I would like column F to add 35 days if...
-
MACRO to copy / paste cell text down various rows [Solved]
Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within...
-
MACRO submit data drop to next row upon submission [Solved]
Hello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the...
-
Recalculation [Solved]
Hi 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...
-
Making my macro independent on future Sheets [Solved]
Hello 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...
-
Outlook syncing/sharing. [Solved]
Hi 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...
-
Making formulas work, which work on other computer [Solved]
Hello, 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...
-
Removing a 'FALSE' result [Solved]
Hello, In the following formula, I am getting a 'FALSE' as opposed to a '0' result. =IF((F28+F31)
-
Multiple IF statements in Excel [Solved]
Hello, 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...
-
Highlighting future dates [Solved]
Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired,...
-
Copy rows to other sheets based on value in column [Solved]
Hello, 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...
-
Make userform [Solved/Closed]
Hello, 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...
-
VBA code for copy & paste items for multiple times [Solved]
Hi, 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....
-
Create sheets for additions to list on sheet one. [Solved]
I 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. ...
-
Overwriting data during transfer [Solved]
Sir, 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...
-
VBA code for command button [Solved/Closed]
hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to...
-
How can I separate each slides from one PPT file? [Solved]
Hi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to...
-
When the field is =N, want to subtract that field [Solved]
Hello, 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...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I...
-
Conditional formatting across multiple columns [Solved]
Hi 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...
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
If a cell contains any text then add a value [Solved/Closed]
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need...
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
Copy conditional formatting for an entire row based on one cell [Solved/Closed]
Hello. I'm working on an Excel sheet, where the entire row is coloured based on the values of two cells in the current row. If one of the cells...
-
Arrow keys not working in Excel [Solved/Closed]
Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. ...
-
Duplicate rows from multiple worksheets [Solved]
Hello, 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...
-
Microsoft Word icon changed to unknown program [Solved/Closed]
Hello, Recently my microsoft word (program) icon changed from the classic picture to the unknown programs icon. I wanted to know how to get...
-
Excel "IF" function w/ date in test cell [Solved/Closed]
Hello, 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...