Posts by tradertt

Re: Vlookup does not work & Wildcard available?

Hi

Thank you for letting me know. As I downloaded it from a source that I do not have control over, is there a way to REMOVE all extra characters on the same column?

Re: Vlookup does not work & Wildcard available?

But even if I type in the space - Vlookup still does not work

Hi

Please have a look at the spreadsheet and see if anyone can advise why Vlookup or Advance filter does not work - #N/A althought the EXACT data is TYPED in.

Can Vlookup accept wildcards?

Re: Save As Hyperlinks in worksheet with a different filename for each

the Webpage the hyperlink is pointing to

Hi

Does anyone know how to setup a macro that can save an excel sheet full of hyperlinks (I have included an example)

The hyperlinks will be SAVE AS - just like when you right click a link in internet explorer and saved into a folder WITH a different UNIQUE filename for each

The filename is NOT important

Does anyone know if excel can do this?

Thanks

Re: Advance Filter - Macro to select cell references and filter it out in the main sheet

Thanks It works perfectly!

Hi

Does anyone know how I can make a macro to advance filter a table so that I can have 3 columns in another worksheet and I key in data and it will automatically filter out the data I want in the main worksheet?

If there are 3 columns to choose from, can a macro be done so that if Column 1 does not have any data in it, it will automatically choose column 2 to find the filtering data and if no data is it in, column 3 will be taken.

Please see the attached file for more details.

Thank you .

Re: Vlookup on MULTIPLE columns before outputting the data

Anyone?

Re: Vlookup on MULTIPLE columns before outputting the data

Hi Thank you. It looks great! How can I read up more on this function or do you have any helpful tips on this?

Hi

Can Vlookup do a Lookup on MULTIPLE columns say Column

Date and Quantity and if BOTH MATCH, then Price is thrown out?

Thanks

Re: Increasing Max number of tables allowed in a pivot table

Hi Anyone?

Hi

Is there a way to increase the maximum allowed table in a pivot table?

Currently the maximum is about 5 right?

Thanks

Re: Covert week number to actual date

Thanks for that. I will give it a try.

Re: Covert week number to actual date

Hi

Would it affect the results? I am not too sure

Re: Covert week number to actual date

Sorry I meant it to be the other way round -

INPUT week 05 and get a date out of it from excel.

Re: Covert week number to actual date

Hi

I am not referring to the weeknum function

I want to convert a date say 1 Feb 2005 to week 05.

How can I do it?

Hi

I have a question to ask.

How can I convert a week number say week 04 to a date?

If it can be done, which day (monday etc) will be reflect?

Thanks

Re: If Data = Negative --> Highlight cell - Without using VBA

Hi

Anyone know if I want to BOLD the WHOLE row A if D1 is negative - and it moves down the page

How do I do it with condtional formatting?

Hi

I have a problem that I hope can be solve.

I have a pivot table that I use everyday that has the same fields

However, the source where it is drawing the data from is changed everyday - (I have the pivot table in a SEPERATE excel sheet)

Is there an easy way to do this as I have to change it source everyday (by right clicking on the pivot table and choosing wizard) and refreshing the data.

By the way, the date of the report changes everyday only

ABC 17 Jan 2005
ABC 18 Jan 2005

etc

Can anyone assist?

Thanks

Re: Duplicate rows / Auto deletion of

May I check - Regarding the Advance Filter - What if some of the rows I had entered some additional data and I want to remove those rows that are DUPLICATE with NO additional data entered in other cells on the same row?