ChipsLetten's user avatar
ChipsLetten's user avatar
ChipsLetten's user avatar
ChipsLetten
  • Member for 8 years, 10 months
  • Last seen more than 1 year ago
  • London
8 votes

Looks at order data and arranges it to focus on order locations

8 votes

Copying and comparing two sheets before deleting duplicates

8 votes
Accepted

Matching between files and a list of filenames at scale

6 votes

Sorting and color-coding based on variables

5 votes
Accepted

Sorting and color-coding based on variables

5 votes

Hide and un-hide rows then sort on Worksheet_Activate event

5 votes
Accepted

Aggregating 2 lists by matching UniqueIDs

5 votes
Accepted

VBA macro which filters and splits dataset into new workbooks

4 votes

Worksheet that lists a person's name

4 votes

Searching a huge number of strings from Excel to a large number of Text files

4 votes

Extracting data from CSV file on the internet

4 votes

Excel macro to move data across workbooks using an ADO connection

3 votes

Converting CSV files to Excel workbooks

3 votes

Copying from sheet to sheet if column headings match

3 votes

Open files, copy area under header, print to mastersheet

3 votes

Hotel reservation system with discounts and deposits

3 votes
Accepted

Copying and pasting from MS Project to MS Excel

3 votes
Accepted

Refer to other cells besides the one in the Cells.Find

3 votes

Filtering and aggregating data from a multi-Worksheet Workbook

2 votes
Accepted

Downloading stock information from Yahoo! Finance

2 votes

Pick out excel cells from a long horizontal list based on an adjacent numerical value

2 votes

Streamlining function that gets the length of each value

2 votes

Adding all IDs associated with a Fax to one Row