Call in the cavalry -- need help solving this thread-prior to 2013

[mikecox]

(remember to post a link to the thread ).

How would I do that?

[davesexcel]

Easiest way,
Click on the address bar Ctrl & c
Ctrl & v to your msg

[NBVC]

Here is another VBA request... that I mistook for a formula solution request


http://www.excelforum.com/excel-prog...23#post2719323

[JBeaucaire]

I'm not that into Pivot Tables, this gent asked for more assistance on his prolonged issue:

http://www.excelforum.com/excel-prog...ly-data-2.html

[arlu1201]

This user needs help in picking up a random cell from range B3:B20 in another sheet and then taking the offset value of that random cell and inputting it into the main sheet. I am lost here. Please help.
http://www.excelforum.com/excel-prog...her-sheet.html

[ChemistB]

Hi All,

Any one want to tackle a graphing problem?
http://www.excelforum.com/excel-gene...html?p=2719675

Thanks

[NBVC]

If anybody fancies coming up with a Regular Expression solutions.. here is one I think could use it....

http://www.excelforum.com/excel-gene...66#post2722566

[tigeravatar]

Anybody got ideas for this one?

http://www.excelforum.com/excel-prog...html?p=2723954

[darkyam]

Tigeravatar, I'm a vba noob, but first thought is turning screenupdate to false. Perhaps this is a question more experienced VBA programmers can answer, but instead of numerous calls to another database, might it be faster to copy the necessary section of data, post it in the current workbook, work from there, and then delete those pages when finished? Just an idea.

[OnErrorGoto0]

Anybody got ideas for this one?

http://www.excelforum.com/excel-prog...html?p=2723954

Following his last post, I can think of a couple of suggestions but none are printable...

[zbor]

Can someone check this: Need macro to enter values from a txt file:

http://www.excelforum.com/excel-gene...-in-excel.html

[jeffreybrown]

Could anybody take a stab at explaining this?

http://www.excelforum.com/excel-gene...us-thread.html

[davesexcel]

Check this out
http://www.excelforum.com/excel-prog...work-book.html

[DGagnon]

If anyone can assist, I think this a bit over my head

http://www.excelforum.com/excel-gene...y-formula.html

[arlu1201]

Please help with this one - http://www.excelforum.com/excel-gene...n-another.html

[ChemistB]

Anyone have a macro for removing the apostrophe but keeping the result as text? Tried text to column tricks but couldn't get it right.

http://www.excelforum.com/excel-gene...ing-issue.html

[TMS]

@ChemistB:

Please Login or Register  to view this content.

Loop as required

Regards, TMS

[DGagnon]

anyone have experience with SMS via excel?

http://www.excelforum.com/excel-prog...excel-vba.html

[arlu1201]

Need help here : http://www.excelforum.com/excel-prog...-is-found.html

[darknation144]

http://www.excelforum.com/excel-gene...ng-issues.html

I don't understand the guys problem with finding the right price any help?

[DGagnon]

I can't seem to work out a simple function for this, can someone else please have a look?

http://www.excelforum.com/excel-2008...mula-help.html

[arlu1201]

Need help here - I might not have the time today to assist this person

http://www.excelforum.com/excel-gene...cted-cell.html

[DGagnon]

I cant view the users file, and dont want to leave them stranded, could someone take a look at this?

http://www.excelforum.com/excel-prog...code-help.html

[Cutter]

I provided a formula solution for this OP based on a fairly simple data sample. It turns out the sample was over-simplified and I think VBA is the only way to go. Could someone with VBA skills have a look?
http://www.excelforum.com/excel-gene...ader-name.html

[protonLeah]

Can someone please have a look at this one. I've been too tired and fizzled out this week and I don't want to leave him hanging.
--------
http://www.excelforum.com/excel-prog...ut-macros.html
--------
Thanks...

[ChemistB]

Thought I had a solution but doesn't seem to be working the way I thought it would. :/

http://www.excelforum.com/excel-gene...-adjusted.html

[Domski]

Anyone want to help this guy?

http://www.excelforum.com/excel-prog...ain-value.html

I think I may have upset him at MrExcel.

Dom

[arlu1201]

Need help with this one - i do not have the expertise in this field

http://www.excelforum.com/excel-prog...t-journal.html

[DGagnon]

Anyone have insite on using Step Into from the VBE?

OP is getting a different result than just running the code.
http://www.excelforum.com/excel-prog...-outright.html

[tom1977]

Hi
If someone can help with this it will be great
http://www.excelforum.com/excel-gene...-a-string.html
create formula OP needs it is far over my skills

[ChemistB]

OP is asking for a VBA solution, moving data to a new tab and removing row from original tab. Thanks in advance

http://www.excelforum.com/excel-gene...asks-help.html

[jeffreybrown]

Could somebody offer a solution to this thread without having to use a helper column?

http://www.excelforum.com/excel-prog...html?p=2764127

I tried some combination of Iserror but couldn't get it to quite work right. With the first macro I posted, it seemed to work, but I had such a small amount of test data I was just fooled into thinking it worked. On a larger set on data I realized it wasn't quite right.

[DGagnon]

Probably an easy post, but i wont have time to get to it this weekend, and i dont want to leave the member stranded

http://www.excelforum.com/excel-gene...-workbook.html

[davesexcel]

Here is one, it became diluted, but help is still required.
The real question is how to be sure that 2 listbox selections are consecutive.
http://www.excelforum.com/excel-prog...-selected.html

[jeffreybrown]

Could I get a hand on a formula solution here...?

http://www.excelforum.com/excel-2007...ple-cells.html

[jeffreybrown]

Would somebody be able to point me in the right direction here.

The OP wants to sort different ranges and I have posted some follow-up questions (at least in my own mind need clarifying).

I'm struggling with how to find the break between the non-contiguous cells. With the code below, the established range is A8:P32, but what can I adjust to have the range defined as A8:P17 since A17 is the last contiguous cell and then the data starts up again in A20?

Please Login or Register  to view this content.

[tigeravatar]

jeffreybrown,

Something like this should do the trick:

Please Login or Register  to view this content.

[tom1977]

Hi Formula Masters if You are still here help this guy
http://www.excelforum.com/excel-2007...e-infront.html
thx

[ChemistB]

Need some Graphing help here. Couldn't combine multiple pivot table results onto 1 chart and when I tried to make Tables with SumIf's the charts looked bad also.

http://www.excelforum.com/excel-gene...t-weekday.html

[jeffreybrown]

Anybody see any other solution here...

http://www.excelforum.com/excel-prog...t-picture.html

[jeffreybrown]

Just a word of advice here please.

Helping a user with a macro to change any sheet in the workbook.

After testing, this macro works on individual sheets, but my question, do I need to use the ByVal Sh As Object?

User enter dollar amount in G4 and then a date in I4
Searches column B for a match to the date entered in I4
Once a match is found, places the value from G4 in same row as date (column B) in column C
If no dollar amount in G4, data validtion in I4 is removed along with the cell being locked

Again, after testing all works well with each indivdual sheet, but do I need to use the ByVal Sh As Object?


Thanks...

Please Login or Register  to view this content.

[shg]

Other than the argument names, you can't change the event signature at all, Jeffrey.

[TMS]

Using the Workbook_SheetChange means that the change code will be actioned for any change on any sheet. The only reason I can think of for needing/using the Sh variable is if you want to specifically include or exclude a sheet or group of sheets from the event code.

Regards, TMS

[jeffreybrown]

Okay thanks to both of you.

[arlu1201]

Need help with this one - http://www.excelforum.com/excel-2007...nt-colour.html

[mrice]

I've submitted a response - maybe it will help.

[arlu1201]

Thank u Martin...

[JosephP]

After testing, this macro works on individual sheets, but my question, do I need to use the ByVal Sh As Object?

yes, you should ideally use it instead of having unqualified range references. and use it instead of target.parent ;-)

[icestationzbra]

the latest requirement on this one is above my pay-grade:

http://www.excelforum.com/excel-gene...tain-time.html

please help...

[martindwilson]

volatile sheet names in vba anyone?
http://www.excelforum.com/excel-2007...ion-below.html

[jeffreybrown]

Anybody want to offer some thoughts here?

http://www.excelforum.com/excel-gene...utofilter.html

[alansidman]

So this one is a bit (actually a major bump) above my expertise in Excel. I don't have a clue as to how to answer. Perhaps one of you can join in this thread and give the OP a solution.

http://www.excelforum.com/excel-gene...-out-list.html

Alan

[arlu1201]

The OP brought up several threads that have not been answered yet, despite repeated bumps. Anyone can assist here?

http://www.excelforum.com/excel-prog...df-button.html
http://www.excelforum.com/excel-prog...two-cells.html
http://www.excelforum.com/excel-prog...-workbook.html

[Andy Pope]

Really ?????

This one for example, http://www.excelforum.com/excel-prog...-workbook.html
You want posters to chase up a thread that is +4months dead, Last post date was 12-23-2011, with a comment in the last post of "I urgently need this to work".

[arlu1201]

I agree Andy.

Actually, i pulled up the OP for a duplicate thread. Thats when he/she PMd me saying he hasnt been receiving replies though bumping the posts several times, hence he/she created a duplicate thread.

The OP just PMd again stating that the link you provided has been solved. But the other 2 havent.

[swordswinger710]

Thank you, arlu1201.

The one I am most desperate for is this one:
http://www.excelforum.com/excel-prog...df-button.html

If anyone could assist, I'd be more than grateful.

[arlu1201]

Need help with PDFs - http://www.excelforum.com/excel-misc...rom-excel.html

[arlu1201]

Need help with this one. Somehow managed to understand the requirements from the user http://www.excelforum.com/excel-misc...l-sheet-2.html

Anyone worked on such allocation queries?

[martindwilson]

code needed here
http://www.excelforum.com/excel-prog...onversion.html
basically its import one or more text type files into excel through automation. but op hasn't said exactly what yet!

[NBVC]

I left this guy hanging.... http://www.excelforum.com/excel-2007...ell-popup.html

I think he needs VBA to do what I think he is asking for... as the formula I gave was not what he was looking for....

[NBVC]

Can anyone with access to Excel 2010 check this thread to confirm what the OP is saying is happening? In 2007, there doesn't seem to be the issue....

http://www.excelforum.com/excel-prog...in-a-cell.html

[jeffreybrown]

If a moderator is available, these two threads can be merged...

http://www.excelforum.com/excel-gene...-easy-but.html

http://www.excelforum.com/excel-gene...-accounts.html

[Paul]

Already closed the first thread since there were no replies with solutions. User can continue in the newer (properly titled) thread.

Thanks!

[jeffreybrown]

Thanks Paul

[JBeaucaire]

Need some new eyes for a formula: http://www.excelforum.com/excel-gene...-weekends.html

[jeffreybrown]

I am out of energy here, but not from a lack of asking/trying. Anybody want to offer some thoughts?

http://www.excelforum.com/excel-gene...f-options.html

[jeffreybrown]

I thought I was getting a better grasp on charts, but this one is proving to be more...

I am comfortable with using the secondary axis, but with this chart, the grouping seems to cause a little dilema I can't overcome.

I'll attach what I have done so far (working tab) by splitting the weeks out into there respective colors (below 95%, 95% - 99%, and above 100&) and matching the output of Filler Eff Graph 1.

Any thoughts?

http://www.excelforum.com/excel-prog...is-values.html

[Mordred]

Can someone help with this as it has to do with dashboards and that's not really my thing. Thanks!

[tigeravatar]

Guh, working with dates seems to be my nemesis >_<
Can anybody lend a helping hand for finishing touches here please?

[icestationzbra]

can someone please help with this?

http://www.excelforum.com/excel-gene...h-vlookup.html

[tigeravatar]

are you sure that's the right link? it goes to a thread where you haven't posted and Bonny seems to be doing fine there until she got saddled with some work, and the OP stated it was fine and he seems to be in no hurry

[Cutter]

Are you sure that's the right link???

[icestationzbra]

@ta/@cutter: it is the right link - i guess that i had not refreshed my browser page for the entire time that i was attempting to solve the issue (which was a very long time), so i did not come to know of any other follow-up.

[Fish10800]

Can someone please help with this ( I believe it is a simple soultion)

Post has to do with chart widths

http://www.excelforum.com/excel-gene...etup-help.html

[Cutter]

This OP is looking for associated values returned from 2 sheets and possibly multiple occurrences of searched values on each sheet.

http://www.excelforum.com/excel-work...onditions.html

[jeffreybrown]

One of you formula guru's have a solution here...

http://www.excelforum.com/excel-prog...attribute.html

[dangelor]

Anyone up on server file use in VBA? Beyond my ken.

http://www.excelforum.com/excel-new-...54#post2795954

Thanks,
Rich

[NBVC]

VBA to hide columns based on condition....

http://www.excelforum.com/excel-gene...15#post2798015

[jeffreybrown]

I can't seem to find the right mix here.

I need to cut the range and then pastespecial as values to a different sheet.

The only way I can think to do it is like this, but I know I am missing something or I should say, if the range has a format it would transfer the format but the OP wants values.

Any thoughts?

Please Login or Register  to view this content.

http://www.excelforum.com/excel-gene...ble-sheet.html

[arlu1201]

Need help with this one....literally going bonkers !!!

http://www.excelforum.com/excel-prog...d-mails-2.html

[FDibbins]

any suggestions on this 1 please?

http://www.excelforum.com/excel-2007...html?p=2797272

[jeffreybrown]

Any idea how to make something out of this?

http://www.excelforum.com/excel-work...early-one.html

[jeffreybrown]

Anybody have any thoughts why this might be happening to this OP?

http://www.excelforum.com/excel-2007...el-2007-a.html

[jeffreybrown]

Anybody up for this...

http://www.excelforum.com/excel-2007...arget-sum.html

[arlu1201]

I am not sure if i have posted this already. But can anybody help with this one - http://www.excelforum.com/excel-prog...-series-3.html

[Mordred]

Perhaps someone will know better than me regarding this.

[arlu1201]

Need a lil help here - http://www.excelforum.com/excel-misc...the-sheet.html

[Søren Larsen]

I'm pretty busy at work and I think this guy could use some help before I get the chance to get around to it (Received a PM to get my attention). Also, i kinda let the guy hanging on the post he is linking to in his new post, so if any of you have the time:

http://www.excelforum.com/excel-2007...22#post2805622

I don't think it's overly complicated...

[Cutter]

This OP is looking for some help to tweak a UDF:

http://www.excelforum.com/excel-prog...rom-value.html

[tigeravatar]

Can anybody help on this thread? I'm not even sure it's possible to do what the user is requesting.

http://www.excelforum.com/excel-gene...html?p=2806986

[tom1977]

Could someone check what is the problem here:
http://www.excelforum.com/excel-gene...ate-range.html

[swordswinger710]

I'd really appreciate any suggestions to my question here.

[martindwilson]

http://www.excelforum.com/excel-prog...et-update.html i have no idea how this workbook was created it has custom toolbar and i cant get the worksheet menu bar back to play with it ,any insight from code person appreciated

[martindwilson]

yet another one this csv has missing columns and i cant see a way to get it to line up(probably could do a load of functions but it would take forever to complete
http://www.excelforum.com/excel-work...tted-file.html thanx

[Marcol]

Re post #493
WARNING: Don't open the attachment in this thread http://www.excelforum.com/excel-prog...et-update.html Post #1 unless you want to reset all of your Excel defaults after you've helped!

[TMS]

@Martin/Marcol: re: post #493 - the OP rather cleverly hides the Workbook_Open and Workbook_Close event handlers way down the Workbook Class Module. So, if you double click to open it, it appears empty ... but it isn't.


Regards, TMS

[martindwilson]

sneaky that!

[martindwilson]

anyone at all for #494 ?guy is still waiting hopefully

[jeffreybrown]

Anybody have some ideas here?

[NBVC]

http://www.excelforum.com/excel-work...16#post2811616

[jeffreybrown]

I'm struggling to understand what the user wants here

[Mordred]

This goes beyond my knowledge and/or I don't quite get the OPs requirements.

[vandan_tanna]

#502: I tried unsuccessfully.

Anybody else want to try?

[Russell Dawson]

Can anybody help with this VBA conditional formatting problem

http://www.excelforum.com/excel-prog...40#post2813940

Thanks

[martindwilson]

another vb cf required here anyone?
http://www.excelforum.com/excel-prog...formating.html

[TMS]

Anyone have any thoughts on this one please: Text Boxes and Pictures will not print - Tried lots of things to no avail!!!


He's right, they don't show up and I can't see any obvious reason ... text box, images, etc ... I've probably checked the same things the OP has and I can't see the problem(s).

Thanks, TMS

[jeffreybrown]

Does anybody have some thoughts to offer on this for the OP...

Not my thread but I was watching it...

[Mordred]

I don't know if the worksheet change event target = target value is what that op was looking for Jeff but it seems reasonable doesn't it if all the op wants is the value?

[jeffreybrown]

Hi Mordred and thanks for the look,

I saw it as they did not want the format carried over from wherever they copied from as not not mess up the format already in place.

[Russell Dawson]

Can anybody help here please.

http://www.excelforum.com/excel-gene...41#post2817841

I’m not sure whether I am understanding correctly and whether there is a solution but I and the OP would welcome any input/suggestions.

Thanks

[arlu1201]

Need help here - http://www.excelforum.com/excel-gene...openxml-2.html

I have not used openxml before and excel crashed each time i tried to move/copy the sheet.

[TMS]

Could someone with Pivot Table expertise have a look at this please: Object Required Error

Thanks, TMS

[TMS]

And any insight into this one. I'm guessing it is something to do with the user's set up because the (single line) code works fine for me.

Problem with MACRO rounding of my values


Thanks TMS


Edit: JosephP offered the solution for this - use Value2 rather than Value.

value2 treats all numeric data as doubles. works the same as value for anything but dates and currencies

[arlu1201]

Can anyone help with this one?

http://www.excelforum.com/excel-prog...long-list.html

[NBVC]

I am not sure if I am understanding the concept correctly here, but I am not sure what to recommend but a UDF Evaluation function of some sort.

If anyone has any inclination to help out the OP here.... http://www.excelforum.com/excel-gene...e-options.html

[NBVC]

I was PM'd for help from OP on this thread: http://www.excelforum.com/excel-prog...combo-box.html

but it involves comboboxes and vba, which as you all know, is not my forte.

Anyway, the OP has 4 combo boxes based on 4 lists.

He/she wants to be able to select an item from any one of these comboboxes, randomly and have the defaults of the other boxes automatically appear with the items from the lists in the same rows as the selected random combobox.

Any help to OP would be appreciated.

[jeffreybrown]

I simply can't follow this one...

Anybody want a go...

http://www.excelforum.com/excel-gene...xcel-file.html

[ChemistB]

Looks like a VBA solution is needed here.

http://www.excelforum.com/excel-gene...h-problem.html
over my head.

[TMS]

@ChemistB: says in the first post - no macros.

[jeffreybrown]

This one requires a mix with Subtotal I believe...!

http://www.excelforum.com/excel-gene...ain-cells.html

[jeffreybrown]

I simply do not see it here

Any takers?

[Søren Larsen]

Anyone up for a macro to dynamically change the number of series in a bar chart? It's way out of my comfort zone:

http://www.excelforum.com/excel-2007...f-formula.html

[arlu1201]

I got a PM from the OP stating that its been a week but not a single reply to this thread http://www.excelforum.com/excel-prog...ring-rows.html.

He/she needed help on it but i am not well-versed with linking Outlook to Excel. Still have to learn that bit.

Can anyone please assist?

[Russell Dawson]

Is anyone able to help here. Matching a range of dates which are in no particular order and alerting to overlaps.

http://www.excelforum.com/excel-gene...87#post2834887

[jeffreybrown]

The OP did not care as much for the UDF Hasseb A offered, he would rather a staight formula.

Anybody have a solution or thought for this?

[jeffreybrown]

Anybody have a formula solution for this last bit?

I think I solved the other pieces for the OP, just not this last part...

http://www.excelforum.com/hello-intr...-everyone.html

[TMS]

Hi Jeff. I suspect the thread shown is not the one you thought it was.

Regards, TMS

[arlu1201]

I got a PM from the OP stating that its been a week but not a single reply to this thread http://www.excelforum.com/excel-prog...ring-rows.html.

He/she needed help on it but i am not well-versed with linking Outlook to Excel. Still have to learn that bit.

Can anyone please assist?

Any takers here? The OP has not received any reply yet.

[daddylonglegs]

Hi Jeff. I suspect the thread shown is not the one you thought it was.

Agreed, presumably this one

[jeffreybrown]

@TMS, yes you are right, wrong thread (I knew I was tired last night)

@DLL, you are right, that is the one.

[jeffreybrown]

Leith provided Worksheet.SetLinkOnData as a possibility to solve this OPs query, but outside of this I do not have any other ideas.

http://www.excelforum.com/excel-prog...html?p=2836482

Anybody have a thought to offer?

[JBeaucaire]

Not sure I can connect fully with OP in this thread, if anyone wants to take over... thanks.

[jeffreybrown]

I can't think of the right solution here.

I'm thinking maybe a fequency formula in column E and then that could be summed up in the pivot table, but not sure. I can't see it

Any assistance is greatly appreciated

[KSSLR]

Can somebody please help this person out? http://www.excelforum.com/excel-prog...92#post2838492

It's pretty basic Excel 2003 code. They're looking to be able to click on a cell in Sheets(1), resulting in a message box that references specific cell values for Sheets(2). "Box that shows up" = Message Box. "Details" = Cell Values from Sheets(2) OP wants referenced in the message box.

Here's the basic syntax for message-box-on-cell-selection-2003 macro:

http://www.mrexcel.com/forum/showthr...electionChange

http://www.ozgrid.com/forum/showthread.php?t=50875

[tigeravatar]

Any formula masters got an idea for this one?
http://www.excelforum.com/excel-gene...html?p=2841761

[abousetta]

Can two drop-down menus be linked without vba? http://www.excelforum.com/excel-prog...e-of-data.html

[MarvinP]

Check out http://www.youtube.com/watch?v=rLRrYPsxGa4

[abousetta]

Thanks MP. The video shows how to use data validation to create the drop-down lists. The OP already have objects in place that they want to populate. I can't seem to be able to do this without vba.

[Russell Dawson]

VBA request - anybody? Seems like I got the wrong idea. OP was after

I was hoping for was a nifty bit of code

http://www.excelforum.com/excel-gene...27#post2843027

Cheers

[tigeravatar]

I don't have a mac and am not sure what is causing the error the user is getting in this thread:
http://www.excelforum.com/excel-prog...html?p=2844175

Any input would be appreciated

[abousetta]

Anyone with a good command of complex formulas why try this one (http://www.excelforum.com/excel-gene...85#post2844085). The OP wants a formula to randomize 35 students to 7 classes with each student taking all 7 classes and no more than 5 students per class.

Thanks.

[martindwilson]

http://www.excelforum.com/excel-2007...file-help.html
needs a bit of code

[FortySixAndTwo]

This thread is confusing to me. Please help as I am somewhat deterred by his/her lack of explanation and confusing code.

[abousetta]

I am not going to be able to followup on this thread. It's not difficult but I just realized I have overdue deadlines I have to attend to. Could someone assist the OP with the vba coding.

[jeffreybrown]

Somebody want to take a crack at a formula here...

http://www.excelforum.com/excel-2007...ng-points.html

[Russell Dawson]

Can someone help here please.

http://www.excelforum.com/excel-gene...44#post2847244

[jeffreybrown]

I'm probably completely missing what the OP wants...

Any thoughts?

[Søren Larsen]

I got into this thread since there seemed no need for a VB solution. After further inquieries it now seems that there is. Can anyone take over?
http://www.excelforum.com/excel-prog...ing-dates.html

[ChemistB]

This one's over my head.

http://www.excelforum.com/excel-gene...ill-color.html

[jeffreybrown]

I'm tapped out and have exceeded my capabilities on this one...

[vandan_tanna]

I am not sure why OP is getting this error. Can anybody else help?

http://www.excelforum.com/excel-prog...ok-button.html

[TMS]

Can anyone answer a INDIRECT.EXT question

Thanks, TMS

[TMS]

@Jerry/Andy: thanks guys. Much appreciated ... right idea, no follow through (on my part)

[Kyle123]

I don't know where to start with this one

http://www.excelforum.com/excel-2007...tor-chart.html

Who fancies it?

[vlady]

Can't pull string here, can anyone help. thanks for the time...

http://www.excelforum.com/excel-gene...condition.html

[martindwilson]

this has given me a head ache,anyone any ideas
http://www.excelforum.com/excel-gene...-of-cells.html

[JBeaucaire]

An OP is trying to use one of my old macros in this thread:

http://www.excelforum.com/excel-prog...me-to-run.html


.... and reporting it takes upwards of 9 minutes to process and create the sheets. I don't understand this, and he's not the first person to ask me about the particular issue. Another OP (can't remember the thread) had the same issue, it worked, but remarkably slow for only needed to process 8-10 loops. Anyone have any insights as to why the copy/create sheets/wbs is causing Excel lag?

[martindwilson]

http://www.excelforum.com/excel-prog...-criteria.html
not at all what i thought! any ideas anyone

[MarvinP]

Hi, I've never seen this behavior before...
on http://www.excelforum.com/excel-prog...are-blank.html
the attachment of "US Employee Tme - Expenses Allowances.." that was attached by the OP.

In Cell A35 of the Template Sheet.
It has the formula of :
=COUNTA(A3:A133)-COUNTA(A4)-COUNTA(A38)-COUNTA(A76)
But the cell has text in it of
"Employees to be paid: 127"

How does this cell get words in front of a number?? Where does this text come from????

[shg]

Look at the number format, which could more simply be "Employees to be paid:" 0

[MarvinP]

You are absolutely correct. I guess this is one more thing I didn't know about Excel. In his Custom Format there all all the slashes in the format. I need to study that a bit to see why.

[shg]

Because those letters have specific formatting significance (like m and d in date formats), and the backslash escapes that significance.

That's why the quoted string is simpler.

[Mordred]

Hi all, this thread is beyond my capabilities.

[Mordred]

Thanks MarvinP

[MarvinP]

Easy Peasy - It might just lead to the OP wanting a class in VBA from us.

I hope my answer was enough to set them on the right track.

[arlu1201]

A formula solution required here -

http://www.excelforum.com/excel-gene...-workbook.html

[TMS]

@Arlette; you jest

[arlu1201]

TMS - formulae is not a piece of cake for me, so sent it over to the experts....

[TMS]

@Arlette: that wasn't the point. I wasn't having a go at you ... I think the OP's requirement is unrealistic. Several sheets, all different structures, different columns to copy ...

I'm sure it is doable, isn't everything, but, in this instance, a VBA solution would seem the best way.

If I were going to do this, and I'm not, I think I'd set up a control sheet listing the sheets and which column(s) need copying and then I'd loop through the list. But that's just my thoughts. It's one thing to copy several sheets where the layout is the same and another with a "random" setup.

Regards, TMS

[arlu1201]

I was going to work out something for the OP thru VBA but (s)he said they do not want a vba solution. So i sent it over here.

Yeah i agree its unrealistic...

[martindwilson]

http://www.excelforum.com/excel-new-...-go-wrong.html
gave a macro but it apparently needs tweaking
come on people i know there are some vba'ers there that this is right up yourstreet

[Haseeb Avarakkan]

Hello Smart peoples,

OP need VBA for 'comma separated list for unique entries' & wrap them every nth word.

http://www.excelforum.com/excel-gene...e-entires.html

[Mordred]

Hi yous! Can someone assist me here?

[Mordred]

I've tried to replicate the crashes from this OP's thread from my work pc but I am not having issues. Anyone else care to have a go at this?

[Haseeb Avarakkan]

VBA Concatenate based on rank

http://www.excelforum.com/excel-form...-and-rank.html

[grizzly6969]

need some help with this
http://www.excelforum.com/excel-gene...3-colours.html

[TMS]

Can anyone help with this, please?

Need VB Code to Extract email address from File name and email the file

Although posted in the Excel programming / VBA / Macros sub-forum, the OP actually wants/needs a VBS (Visual Basic Script) routine to process and email files in a folder. Beyond my limited VBS skills.


Thanks, TMS

[Fotis1991]

Can anyone help with this, please?

I am not able to understand what our new member, asking for.

http://www.excelforum.com/excel-gene...-for-help.html

[MarvinP]

Hi guru's with a nack for Array Formulas.

in http://www.excelforum.com/excel-gene...html?p=2877251

this OP runs an archery tournament with lots of records to filter. An archer shoots a score and gets an award or classification based on how many points they shoot. This OP wants to filter the records and then do a vlookup using the TRUE option to give the classification directly from the table.

I'm imagining an array formula that has a VLookup in front to return the classification. He doesn't like any of my answers and has changed the problem on me. I give up.

[tigeravatar]

Can anybody confirm or deny what I've posited in my last post in this thread?
http://www.excelforum.com/excel-prog...gger-file.html

If what I've stated isn't true, and you can use the auto_open event in the personal workbook to affect the opening of another workbook, I'd be very interested to learn how. But nothing I've tested is working

[JosephP]

auto_open is like workbook_open in so far as it is only triggered by the opening of the container workbook. I reckon your op wants an application level event handler

[ChemistB]

Not sure this can be (or should be?) done. I can't figure out how to do save this file as the OP wants.

http://www.excelforum.com/excel-gene...placement.html

[Mordred]

I created a hide rows procedure that works for me but not the OP. See here and please help if you can.

[Kyle123]

Anyone fancy a challenge? I've posted a workable solution to the question here: http://www.excelforum.com/excel-prog...19#post2881519 but it involves automating ie which I don't like as it's slow.

Normally I would post the data directly to the site with a querytable, the XMLHTTP object or the WinHTTPObject. However the form is set up for multipart/form-data encoding which rules out the querytable (as far as I am aware). Once the data is posted the location is changed in the returned header, so whilst I can post successfully with the XML object won't follow the re-direct (I can see the re-direct is triggered using fiddlr and is directed to the right page) and I can't get the location setting from the returned header. I'd normally get around this using the WinHTTP request, however, it rather annoyingly appends a content-type: utf-8 property to the end of the content-type which is forcing the website to error so the POST is unsuccessful.

Since I've now given up on this, I'd be interested to see if anyone can return the results without automating ie.

[arlu1201]

I am not able to make out a word of what this person is explaining - please try your luck -

http://www.excelforum.com/excel-prog...to-folder.html

[FDibbins]

can anyone help with this, its a real doozy (well at lest, i think so)

http://www.excelforum.com/excel-gene...html?p=2882619

[JBeaucaire]

Here's an odd one. I've given a standard FIND() macro to an OP here: http://www.excelforum.com/excel-prog...-a-folder.html

I warned him to be sure to always include the Lookin and LookAt parameters to make sure they are always set correctly, and he is reporting that doing that actually makes the macro behave erratically on his computer, the opposite of what one would normally observe. Normally leaving them out *could* lead to erratic results.

Anyway, any feedback/new ideas are welcomed.

[john55]

Hello!

The OP asks if is possible to have disabled copy/paste, I suggested a link to a theread solved by Andy but the OP wants for a specific sheet.
Does anybody know if is possible?
Here is the story! Thank you!

http://www.excelforum.com/excel-gene...d-buttons.html

[FDibbins]

please check out this thread and see if any1 can open the OP's file. i have tried 3 times and it just crashes my excel....

http://www.excelforum.com/excel-gene...html?p=2890016

[abousetta]

It opened fine on my computer. Then... I allowed to try and update the links and it hanged for about a minute (no cpu activity or internet activity) until it gave up and gave the error message that it can't update the links.

[FDibbins]

yes, thats the same problem i got, something about unrecoverable errors, and it seemed to open another workbook that was just a white "sheet", no cells or anything

[abousetta]

I didn't get any errors like that and no other workbook opened... it just gave up trying to connect to the other workbook(s)

[JBeaucaire]

I just worked on the original workbook with links disabled, that seemed to get around the problem.

[JBeaucaire]

The macro I wrote the OP in this thread is reported to not be updating the sheets.

I'd appreciate firstly if anyone can spot anything in my macro that might not be correct. If not, then I'm sure a macro of yours... but I can't see anything wrong with the current macro using the sheet layout from post #2.

[FDibbins]

can any VBA guru;s help with this?

http://www.excelforum.com/excel-gene...-dde-link.html

[vandan_tanna]

I am confused by requirements for formula #2. Can anybody else help?

http://www.excelforum.com/excel-gene...selection.html

[ChemistB]

OP wants VBA solution as it is part of a bigger project. Thanks

http://www.excelforum.com/excel-gene...ate-sheet.html

[icestationzbra]

cannot seem to figure any way around this; attempted to use MMULT for the first time ever, that never went anywhere either... way out of my league, i suppose.

http://www.excelforum.com/excel-form...umn-array.html

[martindwilson]

i'd mirror the table with =IF(AND($A2="weight",B2>0.001,COUNTIF($B2:$L2,B2)=1),B2,"") then sum the results

[FDibbins]

i think this 1 needs VBA, can any1 help?

http://www.excelforum.com/excel-form...html?p=2899391