Help creating quick macro - thanks!

[skipper24]

Hi,

I think this should be relatively simple.

I'm trying to automate the process of inputting a certain cell into another cell to the left of a cell. I know that doesn't seem to make sense - but in the attached file, I'm trying to put the County name for each county into the cell to the left of "Total Funded Loan Value" - for example, in cell A13, but for the entire spreadsheet. Is this possible? Thanks so much!!!snlworkbook 1.0.xls

[Obsessed]

This should do it:

Please Login or Register  to view this content.

[skipper24]

Thanks for the quick reply. Could you walk me through where to put that in? Please excuse my ignorance.

Thank you SO much.

[Obsessed]

Adding VBA to a workbook (make sure macros are enabled! - should be saved as either XLSM or XLSB):

1. Copy the sample code that you want to use
2. Open the workbook in which you want to add the code
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4. Choose Insert | Module
5. Where the cursor is flashing, choose Edit | Paste
6. To run code, either press the play button while your cursor is within that macro, or insert shape/button on worksheet and assign macro to it by right clicking on the shape/button and clicking "Assign Macro"

I've attached a workbook with a button that runs your code for you.

[skipper24]

Thanks so much! This forum is awesome.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Obsessed]

Try:

Please Login or Register  to view this content.

Nice Mumps, clever. Why did you Dim City and foundCell?

[Mumps1]

@Obsessed. Thank you for the feedback. Actually, I was a little sloppy in cleaning up the code after trying different approaches. Those two "Dim" lines of code can be deleted. Thanks for picking up on that.

@skipper24: Please delete those 2 lines of code.

[skipper24]

Hey guys, thanks so much for that again. I actually need a little bit more help (hopefully soon I'll learn this myself and will definitely give back on here )

Basically I need to do the same thing on all of the attached files - will those macros work on these as well? - snlworkbook (4).xlssnlworkbook (5).xlssnlworkbook (6).xlssnlworkbook (7).xls

Thank you so much

[skipper24]

Also, for this file - snlworkbook v2 rg.xlsm - if you see what I've done so far in Sheet2 tab, I need to do that for all of them. Is that possible with a Macro?

I really owe you guys.

[Obsessed]

Should for 4 & 5, but not 6 & 7. Those have different wording...in fact, the wording you provided as the trigger to write the city next to it isn't in those last two books.

[Obsessed]

Also, for this file - Attachment 428970 - if you see what I've done so far in Sheet2 tab, I need to do that for all of them. Is that possible with a Macro?

I really owe you guys.

You could...formulas are easier probably. Something like this was done in less than two minutes:

[skipper24]

I'm not sure if this is allowed on here, but I'll venmo/paypal/etc one of you like $5 (or something) if you would be willing to do the same thing - totals in another sheet - for each of those files. Greatly appreciated.

[Obsessed]

No need to pay. Just pay it forward to other forum members when you get the hang of it. That's what I did...I'm still learning a lot every day.

So you want a macro solution for the totals, that I did with formulas above? Do you need help with sheets 6 and 7? Those are a different format.

[skipper24]

Definitely will.

The formula worked just fine, no need for a macro if that's over-complicating it.

I'll get back to you re: 6&7, looking those over now.

[skipper24]

Definitely will.

The formula worked just fine, no need for a macro if that's over-complicating it.

I'll get back to you re: 6&7, looking those over now.

[skipper24]

Obsessed - here is the attachment I referenced.

snlworkbook (5) -complete.xlsm

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )