The discussions

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 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

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

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

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

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

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

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

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

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

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

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

How to convert an attached image to base64 format.

 Solved

Hi All, Hope you are doing good! I would like to convert the attached image into Base64 format in excel via VBA. Is it possible to change the i...

2 replies Last reply on 28 Jan 2021 by
Raj

How to make a running balance column from a credit column and a debit column

 Solved

Hello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...

1 reply Last reply on 28 Jan 2021 by
TrowaD

Populate multiple tabs in an excel spreadsheet based on changes to main tab

 Solved

We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...

1 reply Last reply on 28 Jan 2021 by
TrowaD

Data entered in one sheet automatically appearing in a master sheet

 Solved

I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of ...

1 reply Last reply on 18 Jan 2021 by
TrowaD

If formula for a date range

 Solved

I have two columns, booked date and las rev date for 2021 If the dates in these two columns are between Jan 1 - 24 then it would be a jan report date...

3 replies Last reply on 18 Jan 2021 by
TrowaD

Conditional formatting: font color for entire column based on another column

 Solved

Hi! I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there...

5 replies Last reply on 13 Jan 2021 by
Mazzaropi

Clear cell contents based on value of another cell range using vba

 Solved

I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well. I have a workbook that has over ...

6 replies Last reply on 12 Jan 2021 by
Tbonekiller

Splite the multiple column value copy & paste in other sheet

 Solved

Hello, I want to copy & paste the value of my data sheet, value are save in column & row, i want to splite the spacific rage of column value copy & ...

1 reply Last reply on 5 Jan 2021 by
TrowaD

Copy data from one worksheet to another using spec criteria

 Solved

Hello, I have tried to "customize" other answers similar to this question to fit what I need but I am new to the whole macro thing. I have only use...

14 replies Last reply on 4 Jan 2021 by
vcoolio

Where did page numbers go?

 Solved

Hello, I am trying to set page numbers and from youtube videos, there should be a list of different designs showing here but it is not? How do I...

7 replies Last reply on 25 Dec 2020 by
HelpiOS

Fixing populating values into textboxes based on showing data in listbox

 Solved

hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...

11 replies Last reply on 25 Dec 2020 by
abdelfatah_0230

How to convert the data from pst to eml?

 Solved/Closed

I'm not getting exact solution for this

Last reply on 25 Dec 2020 by
somtochukwu

Matching 2 sheets

 Solved

I'm driving myself mad trying to figure this out. I have 2 sheets. I need to match First & Last name on both sheets. If the name matches, then I need...

1 reply Last reply on 24 Dec 2020 by
TrowaD

Automatically replacing a value in an excel report

 Solved

Hello, I have a CAB Report template with a column called "Change Type" When I extract information the data in this column comes in as either Normal...

4 replies Last reply on 14 Dec 2020 by
NazCarr

Use of if

 Solved

Hello, Guys I am new to excel but I got a complex situation at work. Hope someone can help. I want a formula where if I change the date in one ...

3 replies Last reply on 7 Dec 2020 by
TrowaD

Huge inventory assistance - duplicate a row based on a cell value or quantity

 Solved

I have an inventory list that will end up being ~60k rows of data based on the sum of Col1. tab name - "inventory" Col1 - original quantity Col...

2 replies Last reply on 9 Nov 2020 by
klewis24

Match partial text string in one sheet to another text string in another sheet

 Solved

Hi All, I have two different sheets. In one sheet, I have last names. In the other sheet, I have a column that has cells that contain the person's la...

2 replies Last reply on 5 Nov 2020 by
Santos

Quel bouton utilise cette sous-routine?

 Solved

Bonjour à tous, et merci de lire ma question. Voilà, je dois maintenir un vieux classeur excel qui présente des dizaines de boutons (je suis sous Exc...

2 replies Last reply on 3 Nov 2020 by
ClefDeDouzeEtDemi

Modified code sum repeat data

 Solved

hello actually i search code to sum repeat values and i have about 2000 rows so that's why i do that by code instead of ...

6 replies Last reply on 27 Oct 2020 by
abdelfatah_0230

Changing values in one cell depending on drop down list values in another cell

 Solved

Hello, I have created a drop down(pick list) in cell A1. In cell B1 I want it to show a specific number value based on which selection has been chos...

4 replies Last reply on 26 Oct 2020 by
TrowaD

Loop through range to create new files with dynamic subfolders

 Solved

I would like to have suggestions for a VBA code that does this: Generate an Excel file for each contract number. When copying the contract number t...

3 replies Last reply on 22 Oct 2020 by
TrowaD

Restore setting password for g'five h91

 Solved

Hello, I want to run restore setting on my G'Five H91 hendset, but I dont know what is the password use for it, Please Help Configuration: Wind...

3 replies Last reply on 14 Oct 2020 by
Chohan

With picture names in column, add picture to fit cell dimensions

 Solved

Hello, Im trying to create a macro to bring in images to fit the cell in the column next to the image name This is the code im using and its not wo...

1 reply Last reply on 13 Oct 2020 by
TrowaD

Fill color in row if data is not available sheet 1

 Solved

Dear Experts, In Excel, I have maintained "NAME" and "CODE" lists in Sheet 2. When pasting (copied data from another source) the"NAME" and "CODE" ...

4 replies Last reply on 12 Oct 2020 by
Raj_1562

Grey out an cell and not allowed to enter depending on a cell

 Solved

Hi All, Can you please help me on below request? In column B the name is entered the Column D partner name cell will be grey out and don't allow...

6 replies Last reply on 1 Oct 2020 by
Raj_1562

Modified code create subfolder and save as pdf to it based on cell

 Solved

hi, all i need help to amend my code actually the code works very well but i need some adjusting i would create subfolders based ...

5 replies Last reply on 29 Sep 2020 by
TrowaD

Transfer data from one excel file to another excel file

 Solved

Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?

2 replies Last reply on 18 Sep 2020 by
saurabh2033
Results 101 - 150 out of a total of 2,608