Search results for query: *

Understood. Thank yoU!

Hi all, I work with an investment firm. I have a target cell pulling information from a stock quotes application on a continuous basis. I want the target cell to only pull that information once per day at 1PM rather than continuously. I'm wondering if there is a command that can be added...

Looks like that feature was already turned off. Can you think of anything else that might work?

I have a CSV file that needs to be uploaded into an order management system. The CSV file contains a column full of fees to be charged to clients. The cells are formatted as general so $100.00 is simply shown as 100. The problem I'm running into is when the file is loaded into the OMS, it...

That's what I ended up doing. I stumbled across the advanced filter while messing around with the spreadsheet. I added four rows above the data and listed the loginIDs. It worked great! What a handy tool! MD

Figured it out. Thanks for giving me some direction SkipVought! Best, Michel

I've run into a bit of a snag. Although the IDs are constant, they don't always produce activity during the month and when they don't produce activity, they don't show up on the data file. So I'd like to run a macro but many of the IDs which will be relevant next month are not on this month's...

I need to filter for the same values each month. I was wondering if there was a quick way to filter without having to select the values individually from a drop down menu. The specific values I will be filtering for are loginIDs so they will remain constant over time. Thanks!

Worked perfectly! Thank you very kindly

I have a spreadsheet that contains a list of items on lease. The list is by item description, but I need an aggregated list by asset class. Most of the items are printers or storage units. So I would like to create a column that looks for the words "laserjet", "storage", and "GB". If it sees...

My apologies; it does work! Thank you so much! You're a saint.

Negative. Same issue.

Thanks for the feedback ck1999. Unfortunately, i still get the same error: too many arguments. Any other ideas?

Hello, I am working on a spreadsheet that allocates costs based on information pulled from a pivot table. The spreadsheet matches the userID and product symbol from the target worksheet with the related cost found in the pivot table. The formula I have in place is...