The discussions

Microsoft word letters typing over each other

Hello, How can I fix the above issue? I was typing a Word document and suddenly I see the letters typing over each other.

1 reply Last reply on 22 Jun 2021 by
atupux

Vba: use password to go to sheet

 Solved

Hi, I have a spreadsheet that is driven by VBA buttons that take you to different sheets, I need to password protect some of the sheets, but if an inc...

1 reply Last reply on 21 Jun 2021 by
TrowaD

Auto increase invoice number in this format "te/2021-22/102"

 Solved

Hello, please tell the vba code for increase invoice number to 103,leaving others same on opening worksheet

17 replies Last reply on 8 Jun 2021 by
TrowaD

Command button launches default browser via one line of vba code

 Solved

I have a userform that allows me to use a webbrowser within it, however sometimes due to compatibility issues I need to use microsoft edge and use it ...

1 reply Last reply on 3 Jun 2021 by
TrowaD

Download excel worksheet with formulas (calculation vat inclusive)

The simple Excel formulas (calculation VAT inclusive) Hi there how do I download this example so I can work on it? Thanks Philip

1 reply Last reply on 1 Jun 2021 by
TrowaD

Macro to compare 2 columns and output list with singles and sheet reference

 Solved

Hello, I am trying to write a macro to compare two different columns on two different sheets. and I want to print only the values that are not on ...

1 reply Last reply on 1 Jun 2021 by
TrowaD

How to read data from solar system (api)

Hello, We have a solar panel system from the "solar edge" brand. Does anyone know how i can get the data in powerpoint preferably real time? I...

1 reply Last reply on 1 Jun 2021 by
David Webb  

How to split the amount in excel formula or excel vba code?

 Solved

Dear All, Hope you are doing well!. I would like to copy the value in cell based on user input value. Below is the sample screenshot. The use...

1 reply Last reply on 31 May 2021 by
TrowaD

Forgot my security pattern lock

Hello, Hello, Forgot my security pattern lock? What can i do when i forget my unlock pattern of my gfive mobile? I forget my unlock pattern of ...

1 reply Last reply on 27 May 2021 by
David Webb  

Conditionally formatting if another column contains a specific date

 Solved

Hello, I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has P...

1 reply Last reply on 27 May 2021 by
TrowaD

Multiple logic formula

Hello, I have 2 columns with separate pieces of information: Column A = Wood or Plastic Column B = 1 or 2 How do I build a formula which ca...

1 reply Last reply on 10 May 2021 by
Mazzaropi

Moving the data into previous cell by using excel formula or vba code

 Solved

hi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...

1 reply Last reply on 7 May 2021 by
vcoolio

How to copy cell value from one table to another table with criteria

 Solved

Hi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...

4 replies Last reply on 5 May 2021 by
vcoolio

Grades in excel

 Solved

Hello, How do i do the grades in Excel for example if a learner gets 70% how do i classify that using the symbols to grade the result

2 replies Last reply on 4 May 2021 by
TrowaD

Create multiple copies of excel based on a single template

 Solved

Hello there, I need your help. I need to create multiple excel workbooks using a single template and saving them based on a list of names which ...

9 replies Last reply on 4 May 2021 by
TrowaD

Need help: formula calculating values depending on value in drop down list.

I created a planning tool for my work. It's basically showing situation on a current week, put I need more from it for future planning and also, time ...

1 reply Last reply on 3 May 2021 by
TrowaD

Update sheet 2: specific data is copy and pasted to next row on sheet1

Hello, Please Help! I would like to copy and paste daily data I get onto sheet two. Then using a macro button, copy and past select data from s...

1 reply Last reply on 30 Apr 2021 by
vcoolio

How to fill value in cell if data is not available ?

 Solved

Dear All, Hope you are doing good! I would like to fill the product name as below in Cell if the nearby cell value is filled with some other te...

1 reply Last reply on 29 Apr 2021 by
TrowaD

Create report balances for many customers

 Solved

hi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...

17 replies Last reply on 26 Apr 2021 by
abdomegahri

How to store cell value in a variable excel vba or increase cell value in excel

 Solved

Dear All, Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store i...

1 reply Last reply on 24 Apr 2021 by
vcoolio

How to create a new sheet based on student id numbers

Hello, I am trying to find a code that can make a new sheet based on my students name and ID number. I want to be able for the program to copy the...

2 replies Last reply on 23 Apr 2021 by
vcoolio

Change colour of range of cells based upon text from a drop down menu in another

 Solved

Hi, I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. ...

1 reply Last reply on 22 Apr 2021 by
TrowaD

Automatically run macro from a calculated cell value change

 Solved

Hello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...

1 reply Last reply on 20 Apr 2021 by
TrowaD

Espacement différent entre les paragraphes, s.o.s!

 Closed

Bonjour à tous, mon problème est le suivant: j'écris un livre et de ce fait j'utilise la fonction "titres" pour distinguer des chapitres, je fais do...

1 reply Last reply on 20 Apr 2021 by
TrowaD

Numbering increamental base on value in another colum

Hello, I have different numerical value in one column (say A column), I need to put serial number in another (B) column based in value in A colum...

1 reply Last reply on 20 Apr 2021 by
TrowaD

Auto copy data from sheet1 to sheet based on criteria

 Solved

Hello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...

1 reply Last reply on 20 Apr 2021 by
TrowaD

To highlight or catagorize the data

Hi, I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan) suppose C4A-R1 is placed in any ce...

1 reply Last reply on 20 Apr 2021 by
TrowaD

Vba: copy row ---> lookup value ---> paste in table

Hello, I need help copying a row then lookup a value and paste the row next to the value that has been looked up, constructing a table. Thanks...

1 reply Last reply on 20 Apr 2021 by
TrowaD

Transferring data

Hello, i am having trouble and hopefully someone can help me i am creating an invoice system for the company i am working for and i have created a s...

1 reply Last reply on 16 Apr 2021 by
vcoolio

Vba new sheet and copy template

Hello, Im struggling abit. I want to make a button where I add a new sheet with a specific name. In this example, "App1". But I also want to c...

1 reply Last reply on 10 Apr 2021 by
vcoolio

Calendrier

Bonjour, Voici ma demande puisque je ne parviens pas à solutionner le problème ! En vue de mon prochain championnat, j'ai refait un nouveau calend...

1 reply Last reply on 7 Apr 2021 by
HelpiOS

Modified code copy data from userform to the empty last columns

 Solved

hello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...

17 replies Last reply on 1 Apr 2021 by
leapout

Information transfer

 Solved

Hello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...

1 reply Last reply on 1 Apr 2021 by
TrowaD

Rectify a specific value in specific rows from multiple sheets

Hello, I saw the answer given by Vcoolio that was very useful to me. And how to proceed with the rectification, on especific value, on rows from ...

3 replies Last reply on 30 Mar 2021 by
TrowaD

Word unable opening

Hello, my pc in entire words opening wont properly. im using win7.

2 replies Last reply on 29 Mar 2021 by
scarcity

Copy rows to multiple sheets based on drop down validation

 Solved

Hello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...

5 replies Last reply on 23 Mar 2021 by
vcoolio

Macro that changes a row color at the change of each job number.

 Solved

Hello, I have a spreadsheet that is say 5000 rows long and 15 columns wide and contains production job numbers in Column A. The details associate...

17 replies Last reply on 20 Mar 2021 by
vcoolio

Deleting specific rows from multiple sheets

Hello, I have a question on how to do something specific in excel. I have a workbook with 3 sheets. Sheet 1 contains a master list of records. ...

3 replies Last reply on 15 Mar 2021 by
JDkas

Auto-populating rows from master sheet into other sheets

Hello, I'm attempting to create a distribution list spreadsheet that will have all the names, emails, and agencies in one master sheet, and then h...

1 reply Last reply on 11 Mar 2021 by
vcoolio

Export data from excel to microsoft project

Hi Guys, Could someone help me in telling a way to export the data from excel to Microsoft Project automatically without having to use the import w...

1 reply Last reply on 11 Mar 2021 by
David Webb  

If function

Hello, I have done this function but it keeps saying false and that the formula is wrong even though I did what you suggested by using semi colo...

4 replies Last reply on 6 Mar 2021 by
Mazzaropi

Lookup dropdown list value in a another sheet and copy row accordingly

 Solved

Hello, I am trying to find out if I can create a drop-down list in Sheet1 that when I make my selection, it will copy part of a row from Sheet2 on...

3 replies Last reply on 1 Mar 2021 by
TrowaD

If a cell has a value, make another cell indicate the number 1.

 Solved

Hello, If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific numb...

1 reply Last reply on 27 Feb 2021 by
Mazzaropi

Excel conditional formating using formula

 Solved

Hi All Agian, I have a table with a list of customers and i have columns with the months and on each month i enter the visit day. I want to format...

3 replies Last reply on 26 Feb 2021 by
Mazzaropi

Macro that copy/pastes rows based on a certain condition on same sheet.

 Solved

Hello, I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the r...

1 reply Last reply on 25 Feb 2021 by
TrowaD

Help with average/lookup forumlas

I need help with a formula that will average numbers that meet a certain criteria. . I need break down the average results for each teacher and facili...

1 reply Last reply on 25 Feb 2021 by
TrowaD

How to combine if, and, or functions

 Solved

Increment the backers count by 5 if: The launched at month is January OR September The city is Vancouver AND the country trimmed is Canada If these...

1 reply Last reply on 23 Feb 2021 by
TrowaD

Copy row to another sheet if two (2) criterium are true

Hello, I have a worksheet with seven columns. I need to copy some information to another sheet if b2 is a certain color AND g2 contains contains c...

1 reply Last reply on 15 Feb 2021 by
vcoolio

False in excel spreadsheet

Hello, I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: - =IF($E$3=Sheet1!$A$1,Totals!E6,IF($E$3=She...

1 reply Last reply on 12 Feb 2021 by
Mazzaropi

Computer master password needed

 Solved

Hello, my inspiron 1420 needs a system authentication password and ive tryed so many times to open it bt I need a master password plaese help me than...

2 replies Last reply on 11 Feb 2021 by
Aliraza
Results 201 - 250 out of a total of 12,262