Tagged Questions
0
votes
2answers
24 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
0answers
55 views
Need to find four common data columns in different locations in multiple workbooks
I am working from reports generated from different projects. Each report has varying columns but all have the four columns that I need. I would like to be able to boil the sheets down to these four ...
2
votes
1answer
72 views
Is there any way to programmatically stylize part of a string in a calculated cell in Excel 2010?
Let me explain what I mean.
I have a cell that contains something like this:
="String of text that's moderately long" & YEAR(NOW()) & "."
And I want to know if there's any way that, via ...
0
votes
1answer
1k 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
984 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
1k 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
752 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
370 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 ...
