Office Software Forum
- Excel (9,661)
- Open Office (111)
- Outlook (629)
- PDF (331)
- PowerPoint (169)
- Word (2,171)
-
create report balances for many customers
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...
-
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...
-
espacement différent entre les paragraphes, S.O.S!
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...
-
How to import multiple texte files to multiple Excel files using Power Query
Hello to All Need for help to import multiple csv/txt files to multiple Excel Sheets/files using Power Query Thanks
-
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...
-
PDF editor for desktop like xodo pdf BUT with keyboard shortcuts for editing?
Hi! I am looking for: -A FREE PDF editor -For Desktop (Windows 10) -I use Xodo pdf and it is really good but it does not have shortcuts for ed...
-
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...
-
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...
-
Name Criteria
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...
-
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...
-
Information transfer
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, ...
-
Date of birth
Hello, 05/05/1981 How to write data of birth in word
-
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 ...
-
word unable opening
Hello, my pc in entire words opening wont properly. im using win7.
-
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...
-
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...
-
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...
-
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...
-
Deleting specific rows from multiple sheets [Closed]
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. ...
-
Simple way convert the data from EDB to PST
I'm facing issues regarding this
-
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...
-
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...
-
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...
-
drop down list help
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...
-
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...
-
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...
-
Macro that copy/pastes rows based on a certain condition on SAME sheet.
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...
-
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...
-
How to combine IF, AND, OR functions
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...
-
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...
-
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...
-
computer master password needed [Solved/Closed]
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...
-
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...
-
How to make a running balance column from a Credit column and a Debit column
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...
-
Populate multiple tabs in an excel spreadsheet based on changes to main tab
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...
-
Microsoft Power Bi
I have two sets of data -Data A and Data B. The data is a time range - Entry in and Exit. I need to compare my two sets of data, within Power Bi to d...
-
Copy multiple cells info from sheet if value greater than 0 in another cell
I'm trying to go row by row for a range (c3:c177) to move information from multiple cells in that row that are not grouped together on one sheet to an...
-
Macro to insert row based on variable cell value (text)
Hello, I receive a large data file every week that needs to be formatted into an accounting journal entry. I have very basic VBA knowledge but it w...
-
Data entered in one sheet automatically appearing in a master sheet
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 ...
-
IF formula for a date range
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...
-
How to convert the data from PST to EML? [Solved/Closed]
I'm not getting exact solution for this
-
How do I fix Outlook Error 0x800ccc0f?
Hello, I am facing the Outlook Error 0x800ccc0f issue while incoming or outgoing MS Outlook messages. Please help me to resolve this error.
-
problem code copy invoice data to archive
hi, experts I've found this code from the internet , and I amended some ranges & sheets name , it works but not completely ,there i...
-
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...
-
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 ...
-
VBA Code to Copy Worksheet multiple times and rename based on list [Solved]
Hello, New VBA user.. I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an e...
-
Splite the multiple column value copy & paste in other sheet
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 & ...
-
Teacher
Hello, when I used rank function with count-if function the results of these two function if data has two same number like 292,292 it give the 1,...
-
VLOOKUP problem
Hi ! I have an excel document where I'm trying to use a VLOOKUP formula, however it refers to N#A whereas the value actually is in the column. I...
-
Copy data from one worksheet to another using spec criteria [Solved/Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Install a VPN
- Facebook Code Not Received
- Computer Boots to Black Screen