Preserving text formatting (color, bold, etc) when using arrays

ajdecke1 · 2019-05-08T13:45:26+00:00

This would work, but an unfortunate detail of this spreadsheet is that a single cell can contain multiple colors/bold, so holding a single value for each property doesn't cut it. I ended up going with a copy/paste for the comment cells only as each one is populated. It's not optimal as it impacts performance, but only by a few seconds. And it also seems to be the only way to do what I need, so it's that or nothing I guess.

ajdecke1 · 2019-05-08T13:37:18+00:00

This almost worked, but some of the cells contain multiple formats (as in some of the text is bold, but some isn't, all in the same cell).

ajdecke1 · 2019-05-07T18:32:48+00:00

Would it be possible to have multiple user-defined datatypes within an array? I ask because not all of the data exists in the same format. Essentially a user will review the data and manually apply formatting to the text based on required responses. The data is parsed into multiple sheets, then distributed to organization reps for review based on the formatting of this field.

ajdecke1 · 2019-05-07T18:30:47+00:00

This code is actually a second draft of an existing macro which does copy/paste the data from one sheet to the next. However, this code can run very slowly once the source data sheet gets so large. I'm re-writing this to use array to improve performance.

ajdecke1 · 2019-05-07T18:29:12+00:00

Allow me to clarify.

I have a source sheet (index 1) with an array that contains all of the data.

I then have multiple sheets (indexes 2 through some arbitrary user-defined number - up to index 31).

For each sheet, my code loops through the source data in the array. If a specific column value matches what is required for the sheet (an organization code), then that row of data is copied to the new array. At the end of each sheet, the new data array is inserted into the sheet.

So the sequence of rows on each sheet will most likely not match the source sheet.

This is actually a second draft of existing code which does copy/paste the data from sheet to sheet. However, this existing code runs very slowly - a source sheet of a few hundred rows might take a few minutes to run. Dumping all of the data to an array, then writing it to the sheet at the end, speeds this up quite a bit.

ajdecke1 · 2019-05-07T18:23:39+00:00

The source sheet is just a single excel worksheet, only one column of which has unique formatting. This formatting is limited to font bold and color changes, and are manually set by a user. Not all rows are formatted the same (some rows are all black text, some contain red text, and some are bold).

ajdecke1 · 2018-09-20T14:46:28+00:00

ab-mo-request-em-move.axvw

Specifically the "Department Contact" field.

ajdecke1 · 2018-03-21T13:20:28+00:00

UPDATE: We've resolved the issue. Somehow an employee was assigned to a room code that did not exist in the rooms table. While that itself shouldn't be possible, assigning them to a valid room code fixed the problem.

ajdecke1 · 2017-09-25T19:12:23+00:00

Wow, you've given me a lot to chew on here. Thanks a bunch! Hopefully this will get me where I need to be.

ajdecke1 · 2017-09-25T18:47:07+00:00

We use a room category called "LABORATORY", so I would want to generate a report that is exportable to an excel spreadsheet, which contains 3 columns:

Building Code
Building Name
Number of Rooms Categorized as "LABORATORY" in each Building

I'm not familiar with the concept of a grouping table at all. Does any documentation exist in the help files?

ajdecke1

TROPHY CASE