Forum
Office Software
-
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...
-
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...
-
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
-
How to duplicate rows x number of times
Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A,...
-
Why do my PDF documents open in Word? [Solved/Closed]
Hello, I can't figure out why my PDFs always get open in Word but not the Adobe program? Does anyone have a quick answer? Thank you so...
-
Follow up Q to how to add a certain number of days to a date in excel
Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column,...
-
Macro to copy/paste down X times (where X is the number of rows) [Solved/Closed]
Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The...
-
Compare sheets macro
Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the...
-
Which macro (of many) changes the data in my workbook
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when...
-
RTF to PDF Converter
How can i convert a rtf file to pdf ?
-
Formula to subtract one cell value from another.
Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible? System...
-
Auto Transfer questioner with right answer to another sheet
Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer...
-
VBA code for Insert Picture
Looking for VBA code to help me install different pictures from a drop down icon menu on my excel ribbon. The excel ribbon was created by me with...
-
Inserting day of week along with date [Solved/Closed]
Hello, I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg...
-
Insert Picture in Ms Excell
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures...
-
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