Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
21,058 questions with Microsoft 365 and Office | Excel | For business | Windows tags
3 answers
Chronic "formula becomes text" issue in Excel Tables feature, when a GENERAL formatted formula refers to at TEXT formatted column
The title is a mouthful, but to me, there seems to be a bug in Excel under the following circumstances, that I haven't seen much written about. (Lots about how to fix, but I haven't seen anything on the cause of it). Using an Excel Table specifically.…
Microsoft 365 and Office | Excel | For business | Windows
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 72%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
2 answers
problem to run excel marco with out ms office excel installation on wenserver
Hello, we are searching one solution for our business case: Server: window webserver Service: Webservice in IIS Function: we want to write one function to 1. open excel, 2. call excel marco, 3. save the result in the runtime. problem: we find few…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-09T07:43:11.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYH%3C/text%3E%3C/svg%3E)
Yu, Hai (CTDB1D)
0
Reputation points
answered
2026-10-09T08:57:02.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 59%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nam-D
4,170
Reputation points Microsoft External Staff
Moderator
2 answers
How fix to copy and paste in excel
I am unable to copy and paste in excel and would like to know how to fix this.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T15:24:16.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Allen Banner
0
Reputation points
edited a comment
2026-10-09T06:54:14.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 95%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Anna Bergstrom
0
Reputation points
2 answers
How to filter out any client with specific products in their account
I have an Excel spreadsheet with a list of clients and products as well as account representatives assigned for each client. I need to identify all clients whose combination of products include specific products within that combination and identify…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-09T00:32:26.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lissette Roman
0
Reputation points
edited an answer
2026-10-09T05:41:07.3333333+00:00
Andreas Killer
144.1K
Reputation points
Volunteer Moderator
2 answers
How to fix Input Form copy & paste fail in excel
I have an input form in an excel workbook and I used to be able to copy cells from the workbook into the form text boxes using the normal copy and paste functions - ctrl + v or right click paste but neither of those work any longer, I have to use…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-08T17:33:57.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 41%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Carolyn Butler
0
Reputation points
commented
2026-10-08T19:31:51.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 56.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hendrix
2,070
Reputation points
Independent Advisor
1 answer
COUNTIF formula does not work
this formula has worked before and now it does not. Is there something wrong with syntax? =COUNTIF('All eLearnings'!C:C,A2)
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-08T15:27:24.0133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 96%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Elliott, Shelly (VDSS)
0
Reputation points
answered
2026-10-08T16:34:33.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 83%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chris-D
1,940
Reputation points
Independent Advisor
2 answers
One of the answers was accepted by the question author.
XLOOKUP help
I have a master data tab called “Master FOF” and then one tab for each month of the year. I would like the data from Master FOF to be pulled into the month tabs by matching the names in column A on both tabs (the names match) and the fiscal year month…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 65%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
5 answers
FREEZING SCREEN PROBLEM IN MICROSOFT EXCEL 2024 LSTC 17392.21000
Sometimes, when working in Excel 2024 LSTC , switching between sheets causes the colors and headers to disappear or no longer display correctly. Using the Filter tool can also make all open Excel files become unresponsive, leaving only the options to…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T07:21:16.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 92%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mohsen Safari
0
Reputation points
commented
2026-10-08T11:04:38.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 6%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Michelle Nguyen
1,940
Reputation points
Independent Advisor
5 answers
One of the answers was accepted by the question author.
totals for specific dates formula
Hello! I have been trying to figure out a way to pull specific dates for the month into a totals column but have not been able to figure out a formula that works. I keep getting a #value error. I've tried sumproducts, filter, etc. I want to add the…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 94%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
2 answers
STOP READ ONLY ON ALL EXCEL FILES
SOME EXCEL FILES CHANGED TO READ ONLY. HOW CAN I MAKE THOSE FILES NOT READ ONLY AND HOW I DO I PREVENT FILES BEING CONVERTED TO READ ONLY
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-06T19:21:54.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 9%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alan Phillips
0
Reputation points
commented
2026-10-07T19:39:57.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ryan-N
16,125
Reputation points Microsoft External Staff
Moderator
2 answers
excel saying i cant access file i created
trying to access a file i just created and excel saying i dont have access
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-07T18:37:30.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 80%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
SVDP FoodPantry
0
Reputation points
answered
2026-10-07T18:46:37.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 33%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Lin v
1,550
Reputation points
Independent Advisor
2 answers
Excel will not run
I launched Excel, but after the small "Starting" window appeared, it did not run normally. I am using Windows 11, MS 365 (Business license). The same symptoms occurred even when running in standard mode after disabling and deleting add-ons via…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-08-14T06:37:44.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Carter Lena
0
Reputation points
commented
2026-10-07T13:32:31.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sid risner
0
Reputation points
4 answers
COPY/PASTE not working on Excel 2016
Hi, Just informing you there's some bugs disabling copy/paste on Excel STD 2016 since last Office updates from today 09/09/26. It worked fine yesterday on all computers. Hoping some fix coming soon for Excel 2016 users. Have a nice day.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-09-09T11:34:18.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Vincent CAZENAVE
25
Reputation points
edited a comment
2026-10-07T12:28:47.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECU%3C/text%3E%3C/svg%3E)
Choudhary Umar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Excel Version 2508 Broke Pivot Table Filtering Functionality
Users are getting the following error when trying to filter on a pivot table after update, but was working fine before: "This PivotTable report is invalid. Try Refreshing the data (On the Analyze tab, click Refresh).". Is there a fix for this…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2025-09-02T21:25:59.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 64%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Travis Mills
35
Reputation points
commented
2026-10-07T09:34:02.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gowthaman Vetrivel
0
Reputation points
2 answers
Excel closed on its own and my progress wasn't autorecovered
I turned away to talk to a coworker with several excel sheets open and my unsaved sheet I'd been working on for hours closed. Specific complaints: Excel randomly closed Can't access auto-recover sheets from Excel home, have to open a random sheet to…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T15:34:21.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dan Gilmour
0
Reputation points
commented
2026-10-06T22:57:01.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 32%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay1 Tran
1,620
Reputation points
Independent Advisor
3 answers
One of the answers was accepted by the question author.
editing text in text box in web browser, not in desktop version
I cannot update/edit a textbox on a web browser version? i tried to add a few morecharacters and i got the message to use the desktop version.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-06T06:55:46.7166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 63%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yoshimi Amos
20
Reputation points
accepted
2026-10-06T17:29:28.56+00:00
Yoshimi Amos
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Add addtional formulation in FILTER formula
I filter the data by this formula =FILTER('[Fatigue Assesment_as per 17949_Welded Joints.xlsm]S1'!$E$1466:$F$2065, (BYROW('[Fatigue Assesment_as per 17949_Welded Joints.xlsm]S1'!$E$1466:$E$2065, LAMBDA(r, SUM(r)>0))),"N") I want to delete…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-09-09T12:10:07.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chaturvedi, Santosh
610
Reputation points
edited an answer
2026-10-06T08:07:16.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 15%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Daniel-Vo
6,710
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Macro modify
I want to change this macro so that the liste generted in Data File -- Cell F5 to end sall align in left Sub CopyAndListSheets() Dim wsData As Worksheet Dim wsTemplate As Worksheet Dim wsNew As Worksheet Dim copyAfter As Worksheet Dim cell As…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T14:18:24.9233333+00:00
Chaturvedi, Santosh
610
Reputation points
accepted
2026-10-06T07:25:01.7366667+00:00
Chaturvedi, Santosh
610
Reputation points
1 answer
One of the answers was accepted by the question author.
Modify macro so that ithe liste contents shall reformated to its left side
Can u modify the below macro so that the final liste in F20 shall be placed at right side of the table.. Sub CopyAndRenameSheets() Dim wsDash As Worksheet Dim wsTemplate As Worksheet Dim wsNew As Worksheet Dim wsInsertAfter As Worksheet Dim lastRow…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T11:01:44.9033333+00:00
Chaturvedi, Santosh
610
Reputation points
accepted
2026-10-05T13:25:45.46+00:00
Chaturvedi, Santosh
610
Reputation points
2 answers
One of the answers was accepted by the question author.
MAcro to calculate : (F6=(C6+E6)/2
I have req. I have one front sheet name "DB Collectives". This sheet have liste of hyperlinked sheet written from cell C4 to its end. The macro shall go to each sheets name mentioned in "DB Collectives" in step 1 Then, It should…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,058 questions
asked
2026-10-05T08:42:04.4466667+00:00
Chaturvedi, Santosh
610
Reputation points
accepted
2026-10-05T09:19:42.58+00:00
Chaturvedi, Santosh
610
Reputation points