133
questions
-1
votes
0
answers
12
views
Data usage in programs [closed]
I work in a non tech company with large amounts of data,I'm an analyst and i got basicly moved to a role of a "Data engineer" which I'm the only one handeling it, and as first of a kind ...
0
votes
0
answers
7
views
EPPlus 7.3.2 Can't copy a worksheet from one workbook to another
I have looked everywhere for examples of how to copy a worksheet from one workbook to another. They all seem to say use Workbook.Worksheets.Add(Name, SheetToCopy).
My code below does everything I ...
0
votes
2
answers
12
views
How to use the output of a CONCAT() function as an array in Excel
I would like to use the output of a CONCAT() function as the title for an array within XLOOKUP(). The XLOOKUP() formula I am using that works is:
=XLOOKUP(MetricDesired,'2023-12-13_000_Report.txt'!$C:...
- 13
0
votes
1
answer
14
views
Write pandas dataframe to excel consume too much memory
I am using this code to write a dataframe into excel file:
with pd.ExcelWriter(file_data, engine='xlsxwriter',engine_kwargs={"options": {"strings_to_formulas": False}}) as writer:
...
- 853
0
votes
1
answer
21
views
Can't Debug When Calling Function From Cell
I'm trying to call a function from a formula in a cell. In this case:
=CompareColors(test1, test2)
Where test1 and test2 are named ranges. The function returns the value as expected, but I'm never ...
- 155
0
votes
0
answers
17
views
Tracking Changes in an Excel Audit Trail
I've built an excel audit trail and would like to correctly track previous changes using VBA.
Currently, changes are tracked with "0" as the previous value but I'd like to ensure the cell ...
- 1
0
votes
0
answers
21
views
VBScript (vb.net) to save file as .xlsx not .xls
I have an ssis package that calls an ssrs report and it works fine with the exception of how it's saving the excel output.
simply changing the file extension to xlsx does not work, it corrupts the ...
- 1,195
-1
votes
3
answers
21
views
VBA or formula to repeat a list of items, and for each repeated list, add a location name from a separate locations list
I have a list of items that I want to repeat multiple times, once for each location. Then I need to add the location to an adjacent column for each item. I'm looking for a macro or formula that would ...
0
votes
0
answers
10
views
How to overlay bars in a stacked bar chart in Excel? [migrated]
I have two sources of data: Component data & Total data.
I would like them to both be shown in one chart in a "bar" format. The smaller (in magnitude) would have its color shown in the ...
-2
votes
0
answers
22
views
Introduce a variable (X) in a range call [duplicate]
Need the correct syntax for this Range call
Cell A1 will be a constant
Data will be added/subtracted from Col 1
"X" will be valued by a last cell used in a Col search.
Range(A1:A"X"...
- 1
0
votes
2
answers
26
views
Pivot Chart no longer responding to VBA code to update the chart type of a named data series - Microsoft Excel
Background
I have inherited a large workbook that contains a significant amount of data which is updated on a monthly basis. This data is summarised in a series of 6 pivot charts, all with subtle ...
1
vote
2
answers
48
views
Modify Text Colum while Preserving Its Format
I am trying to modify cells of a text column. In particular, I want to be able to remove a part of the text (XXX_) and strikethrough the part that succeeds it (YYYY). Moreover, I also want to preserve ...
- 57
1
vote
3
answers
62
views
How to match large data on excel based on some criteria?
I am using MS Office Pro Plus 2019. I have an excel that has 6 columns inside.
A = ARMADAW, B = ARMADAS, D = SAPIWC, E = ARMADAIWC, G = SAPW, H = SAPS
I would like to color the matching values B and ...
- 455
0
votes
1
answer
35
views
Search the latest saved PDF file in a various folders and copy the latest one to a specific location
I need a VBA Excel macro to find the latest saved PDF file in the folders and sub folder to get the latest (Creation date and time), then that needs to copy to a specific location.
The code below ...
-1
votes
1
answer
17
views
openpyxl merged column is not centered
I'm trying to center a text along a merged column.
I saw some examples and saw this was the way
ws.merge_cells('A1:Q1')
ws['A1'] = tableTitle
title_cell = ws['A1']
title_cell.font = bold_font
...
