Office Software Forum
- Excel (9,634)
- Open Office (110)
- Outlook (628)
- PDF (330)
- PowerPoint (169)
- Word (2,168)
-
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...
-
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...
-
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 an attached image to Base64 format.
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 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...
-
Simple way convert the data from EDB to PST
I'm facing issues regarding this
-
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...
-
Change fill color depending upon the yes or no dropdown options. [Closed]
Hi, My question I want to create a vba code for yes or no If yes- If my columns C-N are blank, I want it to be highlighted by some color and afte...
-
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...
-
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...
-
Matching 2 sheets
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...
-
more font with a few characters inside each
Hello, I hope I am not OT with my question ... Why when I go to extract the fonts embedded in a pdf file I have several fonts with the same name (...
-
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...
-
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 ...
-
Formatting Date
My bank has organised my dates as dd/mm/yyyy which is about as useful as a hip pocket in your singlet. The logical way to organise dates is yyyy/mm...
-
keyboard shortcut for Smart Lookup
In Microsoft Word, I cannot create a keyboard shortcut for Smart Lookup (búsqueda inteligente in Spanish). How can I do it? I cannot find it in the me...
-
People Folder in Outlook no longer contains any Contacts
Hello. I hope someone can help me. I have Windows 10 and Microsoft Office Professional Plus 2016. When I open the "People" folder in Outlook, it is em...
-
Use Outlook for my Yahoo email
ive been trying for 2 days to use outlook for my yahoo email...no go
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
Problèmes de barres d'erreurs sur Excel 2010
Bonjour, Je vous présente mon problème. J'ai calculé mes écarts moyens avec la fonction de Excel. J'ai ensuite fais "autres options de barres d'err...
-
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...
-
Restore setting password for G'Five H91 [Solved/Closed]
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...
-
Add an asterisk to specific words
How do you formulate multiple cells in a calendar to place an asterisk at the end of the specific words: Eg: Homework due * (everyday Saturday) ...
-
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...
-
Document Convert to Base64 in excel
Hello All, I have a query is this possible in excel? I would like to add a document (pdf/image/word file) in excel. Can that document data be c...
-
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" ...
-
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...
-
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 ...
-
Encoding?
One of my documents is in text form. How do I read it? It is mostly squares.
-
Transfer data from one excel file to another excel file [Solved/Closed]
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?
-
Auto generate serial number in excel based on Column [Solved]
Dear All, I would like to auto update Serial Number based on column D in excel using excel formula. like: Thanks Raj
-
How to copy the Column value into Rows [Solved]
Dear Experts, I would like to copy the team name according to the image shown below. For your reference i differentiate 3 combination but I wou...
-
Rearranging data [Solved]
Hello, We work on a lot of data which is not structured the way we are supposed to use it. Am looking for a script in excel to search for a word in...
-
Auto generate serial number in excel based on input value [Solved]
Dear Expert, I want to auto generate the S.No in column A5 based on input value. I have to enter the No. of record in column C3(Ex: 3).The serial ...
-
keep the data even after the date change [Solved]
Hello, i have 2 sheets one is for the data called employee cost which is having a calculation of employees EOS and the other sheet is a report she...
-
Multiple Rows to one Row [Solved]
Hi, I have data supplied as - And require it to be copied to this format- How can i do this without multiple copy and pasting. Than...
Subscribe To Our Newsletter!
