Forum
Office Software
-
Find a date in a calendar
Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an...
-
VBA Help
Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input...
-
CODE SUM DATA TWO SHEETS
hi, expert i have sheet1 contain data from range a4:e and the sheet2 contains data from range a3:g i would sum the data in sheet1 from b4:e...
-
Copy data to a master sheet from newly created sheet
Hello, I have a master sheet that I want to automatically fill. I have a macro that creates a new sheet for each instance, I now need another...
-
Creating Graph that updates
Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I...
-
Need to extract the data from one page to another page based on the unique numbe
Hi i have data like below mentioned format, need to extract and paste it in another sheet, please help me in...
-
jinco wireless-n USB adapter
Hello, sir & madam i will purchase for wireless-n USB Adapter so install from applacation System Configuration: Windows / Chrome 76.0.3809.132
-
Yahoo account will not connect
I try to add my yahoo account in outlook. I input the appropriate settings imap.mail.yahoo.com port 993 encryption method...
-
VBA Coding
I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1...
-
Arrow keys not working
Hello, my arrow keys are not working. up down left right System Configuration: Windows / Edge 16.16299
-
How to automatically number the pages in a document
How could the engineers who designed Open Office be so bloody stupid? I mean what is so complicated for a software engineer to design something...
-
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...
-
Excel 2013 to extract text in one cell
Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to...
-
how to transfer data from sheet to sheet 2
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that...
-
IF statement [Solved]
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion...
-
Dynamically Assign a Number in Data Set
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can...
-
transfer data from userform to sheet with the same format of table
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in...
-
How to find the latest time per name in a table with names and times [Solved]
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have...
-
Need to create linked sheets
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is...
-
SUMPRODUCT Based on WBS
-
INTEREST ON TERM LOAN AND WORKING CAPITAL [Solved/Closed]
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to...
-
get help Macro sheet
Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i...
-
Spreadsheet help moving data
So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being...
-
Excel vba to color row based on wbs level
Hello I need a macro to change row color based on "Level" column. Thanks Ebti
-
Copy from one cell and paste to another sheet based on length of another column
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy...
-
Summarise hours incurred by month based on multiple criteria [Solved]
Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below...
-
Open Office page numbering - start numbering on page 3 [Solved]
I would like to know how to start the page numbering on page 3 instead of 1.
-
how to reset my nokia 1202-2 pin code [Closed]
Hello, im forgot my nokia 1202-2 pin code
-
Are you still taking questions?
Hello, Are you still taking questions? System Configuration: Windows / Chrome 76.0.3809.100
-
Message to appear when 5 cells uncolored cells contain values. [Solved]
Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values....
-
Code to move rows into another sheet based on certain values [Solved]
Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data...
-
create an ordering list for our consumables
Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an...
-
False Value removal
Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))
-
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output
Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values...
-
Inserting an image without the white background [Solved/Closed]
Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square...
-
Creating a data input sheet with excel
Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is...
-
Count cells containing text per row
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each...
-
Excel Formula to identify similar text
Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word...
-
update Open Office failed
I did as you directed for updating Open Office but "update failed" several times what should I do next? thank you
-
Search using variable
Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in...
-
Auto-populate a sheet with data from different other sheets [Solved]
Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all...
-
Copy rows to other sheets based on value in column [Solved]
Hello, System Configuration: Windows / Chrome 75.0.3770.142 I have copy and pasted the code used to solve the problem for the question which...
-
transfer data from sheet1 to sheet2
Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna...
-
macro code vba exel sum dublicate data and delete
hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum...
-
Copy Template, Rename based on a reference list from a different spreadsheet
Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my...
-
Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved]
Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying...
-
how to merge bank statement into one column
Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should...
-
Copying Excel data from one sheet to another based upon contents of a cell
Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email...
-
MS Word not displaying page numbers, images [Solved/Closed]
Hello, So far MS word worked fine. But now it is not showing up images. Also not even page numbers. Instead showing up {Page}. Please let me...
-
Am not too good on percentage calculation [Solved/Closed]
Hello please what is the 10 percent of,7200000000
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD