Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Troubleshooting Question

Import new CSV file data in to an existing Excel workbook with predefined formats

1

I have an Excel Worksheet ( cal_cost.xlsx ) with predefined column headers. Some examples of the

Troubleshooting Question

vba to create a folder based on a path in the open workbook cell

byEuro5
2

I want to use vba to create a folder based on a path saved in the 

Open workbook, 

Troubleshooting Question

SharePoint Issue with Excel sheet with hyperlinks

2

Hello,

 

We have an Excel spreadsheet within a SharePoint folder that for whatever reason the

Advice Question

How to format Microsoft Forms Excel responses for time sheets

4

We want to implement a new time sheet solution for our employees. We are used to them sending us

Troubleshooting Question

Moving rows by value

1

Hello,


I got the following from youtube and added to it to meet my needs (just added a little bit.)

Advice Question

Excel Data Model - Equivalent of vlookup in worksheet table to cross-ref Data Model Table

I have a table in the data model (loaded from a query) with only 2 columns: (1) ID, which is a text

Troubleshooting Question

Highlight Closest Value based on another cell value.

7

I have a number in cell M14 and a table with a range of a3-j3 (this includes headers) that can

Troubleshooting Question

EXcel first in first out 12 month expiration time

byTom M
10

Column a is the month, Column b is the monthly Generation credits and Column c is the month amount

Troubleshooting Question

Converting Cells with Excel formula into Power Query

Hello, 

I'm new to Power Query.  I'm working on a project where I still need to convert formulas I

Troubleshooting Question

macros not digitally signed in excel 2003

3

A customer of mine, running windows 7 with microsoft excel 2003 had me change his hard drive to a

Research Question

Looking for afterhour input excel template

1

Hi experts,

I need help from the IT professionals to check if anyone is using excel file to track

Troubleshooting Question

Create Hyperlink to Excel Sheets on Sheet 1

4

I have created some code with Python that extracts historical stock data. I want the first page to

Troubleshooting Question

Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria

18

Experts,


I have an Excel VBA question about copying data from 8 spreadsheets into a master

Advice Question

Programmatically access Microsoft 365 Copilot from an Office Add-In

2

As a C# developer with experience using VSTO to create add-ins for Excel and Word, I'm very

Troubleshooting Question

Is there a way or workaround to auto refresh the excel file without opening it ?

8

Hello,

Is there a way or workaround to auto refresh the excel file without opening it ?


Thank you.

Troubleshooting Question

Excel VBA Code - Copying Image To Wrong Sheet

8

The following Excel VBA code executes when a spreadsheet is opened on a schedule to achieve.an

Troubleshooting Question

Convert Excel to XSD Schema

3

Experts,


I have to load data into a web-based database where I can enter each record manually by

Troubleshooting Question

Office 365 lost recent and pinned files list

1

I have lost my pinned and recent files list in excel and word 365.  see screenshots of another

Troubleshooting Question

Date Picker (Pop Up Calender)

3

Please add solution in attached excel. Thanks!

Question Dt picker.xlsx


How to:


1. add code so that on

Advice Question

Dynamic value list in excel

13

Is it possible to have a dynamic value list?  

If a value is used once in a column, can it be hidden

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more