2
votes
1answer
36 views

Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this: a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0 What I want to do is to search for each row for the element 1 and return its ...
0
votes
1answer
41 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
0
votes
1answer
53 views

Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...
0
votes
1answer
51 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
-1
votes
1answer
41 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
0answers
49 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...
2
votes
0answers
236 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
-1
votes
1answer
29 views

Need Macro to perform formula based on cell not number

I am working on a budget workbook and in column I (I5-I1135) I have numbers that I need to upon prompt (such as CTRL C) have the numbers divide by 10 then multiply by 12.. Example: cell I5 has ...
0
votes
0answers
27 views

How to use the Integer i.e. currentregion's row from the macro in a cell's formula

How do I use the row from the current cell, in another Cell's Formula on another sheet? I created this Macro, but don't know how to use the Integer from the macro in a cell's formula. In a macro I ...
0
votes
0answers
96 views

Excel - How do I write a formula or a macro to copy cells to a JPG file properties?

I have over 1000 jpg files and one excel file with all the properties(metadata) for them - title, subject and tags. The excel looks like this: Number ......Title ....... ...... Subject .. ...
0
votes
1answer
382 views

Find and Replace VBA/Macro in Excel 2010

Another Excel VBA question. I'm using Excel 2010 I want to create a Macro that will remove the following 3 symbols in any cell for a selected range: [ ] " For example; If I select a range of ...
1
vote
1answer
322 views

excel macro with column criteria to copy two rows in one sheet to another

I need a macro that searches for a string in a column; on finding that string it copies the row in which that string is found as well as the row above that. For example: Search for "boy" in column ...
0
votes
0answers
399 views

Create a Macro that searches, copies and Exports from two workbooks and imports into 1 master workbook

I am new to creating macros. I have tried searching for existing macros to help with my current request; however I have not found a helpful one. Please let me know if you can assist. Contents ...
0
votes
0answers
31 views

I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...
3
votes
2answers
473 views

Get first and last value from range in a spreadsheet using other column's data for filter criteria

I have data in my spreadsheet in a worksheet like this: Where the data goes in this format [ID] | [Date] | [Hour] | And I have another worksheet where I want the data to be like this: Where I ...
0
votes
2answers
77 views

Need simple macro for “match” formula

Are column B cells hidden somewhere anywhere in column C? Give results in column A. (true/false or yes/no) I'm unable to post the simple Excel image I've created as I'm a guest, but it shows simply ...
0
votes
3answers
479 views

How do I separate three different phone numbers concatenated in one cell into three new rows?

I am doing work for a client and need to know how to separate these phone numbers. I have 0121 396 0501 / 0121 123 434* / 0797 978 8265 in one cell and I want to end up with the same row ...
2
votes
2answers
87 views

Excel macro checks if there is formula

I want to make a macro that checks if that cell get its value from a formula. I cann't find anything similar. Any tips??
2
votes
1answer
167 views

How to programmatically stylize part of a string in a calculated cell

I have a cell that contains something like this: ="String of text that's moderately long" & YEAR(NOW()) & "." I want to know if there's any way that, via macro, I can colorize/stylize PART ...
0
votes
1answer
3k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
3k views

Auto create folders using Excel field entries

I need to generate folders containing certain Excel field entries: Additionally, I need to append a date to the folder name based on that entry So If I have the above Excel table, I'd need the ...
1
vote
3answers
3k views

How do I transpose data in columns to rows?

How do I transpose data in columns to rows? If the data is: Joe some city some state Bob no city no state and I use Paste Special » Transpose, I get Joe some city some state Bob ...
1
vote
1answer
2k views

Prevent Excel 2010 user from pasting formatting into cell

Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...
3
votes
3answers
767 views

Is there a way to set the name box of a cell programmatically in Excel

I would like to programmatically set the name box of a cell in a worksheet I'm working on, either through a formula or through a macro. The end point is that I don't want to set it by hand. In my ...
0
votes
1answer
689 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...