Questions

9 answers

variable xlookup

i have a number in cell AR20 and AR21 - these numbers will change when my spreadsheet is in use so lets assume my numbers initially are 21 and 22 respectively I have a look up chart in B20 to AL56 i want Xlookup to read AR20 [no. 21] down column B - that…

asked

Anonymous

10 answers

how do I add my name and initials to track changes

I need to add my name and initials to track changes

asked

Anonymous

3 answers

VBA MACRO - COPY DATA FROM MULTIPLE CSV FILES IN A CONSTANT FOLDER TO A NEW WORKBOOK (IN .XLS)

To whom it may concern, I would like to ask you if you can help me on this issue. I am writing a Macro in VBA to automatize a process. What I want to do is listed as follow: I have many *.csv files in a folder and I want to copy some dates from these…

asked

Anonymous

1 answer

Excel 365 On Line: End-Shift-Down Arrow button does not work

I use End-Shift-Down Arrow to highlight columns of numbers all of the time. Now that we are working on the online/web version of Excel, it does not work and I am stuck scrolling down thousands of rows. What is the work around? I've searched but…

asked

Anonymous

16 answers

Where can I find folders locally on Android that I have set as "available offline", such that other apps can make use of them?

I'm trying to synchronise notes on the program/app Obsidian on Windows and Android. One important feature of this app is that it can take any folder and use it as the "vault" where notes are stored. Using the Windows version of the app, I have…

asked

Anonymous

1 answer

my SEND button has disappeared. How do i get it back

my send button on hotmail has disappeared. how can i restore it

asked

Anonymous

1 answer

how to safely find and remove duplicate files

asked

Anonymous

1 answer

ORG CHART SMART ART DISAPPERED

I made a whole organizational chart saved it and now I'm having a very difficult time trying to edit the whole diagram. The text panel won't appear in addition to all the other smart art design features. Please help. I am in a time crunch to fix this…

asked

Anonymous

2 answers

Trying to change date format from MM-DD-YYYY to DD-MM-YYYY

I am trying to change the date format from MM/DD/YYYY to DD/MM/YYYY after changing the region setting. The date on formula bar shows the correct one but does not reflect it in the cell,I have restarted the computer but no change in the outcome. I am…

asked

Anonymous

2 answers

Why is Forms not refreshing after it's completed?

Once the form is completed and submitted, it does not refresh to a new form anymore, it stays on the previous one. Before I would complete the form, save as a pdf and then it would give me the option to click "submit another response" now it…

asked

Anonymous

4 answers

How do I delete a line of special characters in Word?

How do I delete a line of special characters in Word? In a Word document I entered three asterisks then I inadvertently hit the Enter Key and the asterisks repeated to the end of the line as little squares. I am unable to delete the line. A backspace at…

asked

Anonymous

3 answers

Can and how when using TEXTSPLIT can it be converted to show as a colunn instean of a row.

When I use PivotData, all the results appear as per screenshot in row 5. How using TEXTSPLIT can it be converted to each cell down. (DAX codes interfere with what I…

asked

Anonymous

5 answers

Your account was not set up on this device because device management could not be enabled.

This message used to appear when logging in, but nowadays I can't authenticate my student college's MICROSOFT 365 account because of this. I connect nowadays and it doesn't even show any messages, just simply won't authenticate. And it will work in any…

asked

Anonymous

1 answer

Can a SharePoint list automatically create subtasks when a new item is created?

I'm trying to develop an Engineering change log, where when a new change is being implemented an item is added to a SharePoint list that will automatically populate subtasks, or child tasks, that can be assigned out to different departments. Looking to…

asked

Anonymous

15 answers

Excel Function and VBA Coding

Dear Sir, I want to know if there is a function in Excel or VBA feature in Excel wherein we can insert particular value say cell no AA87 value in Table of Cells like below table in appropriate cell based on row and column number , Column Number is…

asked

Anonymous

6 answers

Force a spreadsheet to re-calculate each day using VBA

This question is a re-statement of mu previous question "How to force a spreadsheet to recalculate even when no changes are made REPOST". I'm posting this new question because that question has had little response. This is not to disparage the…

asked

Anonymous

3 answers

I need an excel formula for a truck load out for our company vs invatory

Looking to look at our inventory of equipment which consist of different values of each piece. Which I have done so far and had a value returned to how much = per load out for each piece of equipment. Now I need to make a formula that if all the columns…

asked

Anonymous

19 answers

OneDrive Can't Start - How to remediate?

1 This "OneDrive can't start" error has been reoccurring on a number of our User's devices. Reset commands within the Package contents of OneDrive have been unsuccessful in efforts to remediate the issue. This error has been present primarily…

asked

Anonymous

1 answer

Non-Programmer Needs to Disable "Excel Found a Problem With One or More References"

Hi! I'm working on my custom 2023 budget in Excel and keep encountering the most ANNOYING issue: I'm patterning this year's custom budget after last year's. However, despite copying the sheets over, I've made multiple changes to each sheet for 2023,…

asked

Anonymous

2 answers

Help with Microsoft forms and formulas populating in workbook

Hello, I am using Microsoft Forms and have noticed that when respondents enter free-text numbers in the form, the resulting data in the connected Excel workbook is not recognized as numeric values. This issue is hindering my ability to perform…

asked

Anonymous

Filter

Content

1,810,045 questions

variable xlookup

how do I add my name and initials to track changes

VBA MACRO - COPY DATA FROM MULTIPLE CSV FILES IN A CONSTANT FOLDER TO A NEW WORKBOOK (IN .XLS)

Excel 365 On Line: End-Shift-Down Arrow button does not work

Where can I find folders locally on Android that I have set as "available offline", such that other apps can make use of them?

my SEND button has disappeared. How do i get it back

how to safely find and remove duplicate files

ORG CHART SMART ART DISAPPERED

Trying to change date format from MM-DD-YYYY to DD-MM-YYYY

Why is Forms not refreshing after it's completed?

How do I delete a line of special characters in Word?

Can and how when using TEXTSPLIT can it be converted to show as a colunn instean of a row.

Your account was not set up on this device because device management could not be enabled.

Can a SharePoint list automatically create subtasks when a new item is created?

Excel Function and VBA Coding

Force a spreadsheet to re-calculate each day using VBA

I need an excel formula for a truck load out for our company vs invatory

OneDrive Can't Start - How to remediate?

Non-Programmer Needs to Disable "Excel Found a Problem With One or More References"

Help with Microsoft forms and formulas populating in workbook