Posts by markl

Perfect!

Thanks very much

Mark

Good Afternoon,

I have an access form with a combo box (combo_rule) that lists a number of queries.

When I hit the run button, I woul like to run the query that has been selected in the combo box.

Can anyone advise the best way to do this

Thanks

Mark

Re: Delete anything that is not bold

Apologies,

When I created this thread I was presented with similar threads one of which provided me with my answer. I did not realise I had actually posted this

This thread can be closed

Thanks

Markl

I have a spreadsheet which contains standard and bold text in the same cell I would like to delete anything that is not bold

Can anyone assist

Thanks

Mark

Re: Loop through cells in column and save file name as per cell content

Found this solution

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

Works perfect

I have a spreadsheet containing two columns.

The first column contains the name of a file I wish to save a copy of the file based on the contents of the second column.

As you can see from the attached, the same file may need saving several times as a new name.

Is this something that can be done via excel?

Any help would be gratefully accepted

Markl

Re: Repeat Rows By Mutiplying Current Amount Of Rows By Cell Value

That is exactly what I want.

Thanks very much - you are a star

Mark

Re: Repeat Rows By Mutiplying Current Amount Of Rows By Cell Value

Robert,

Thanks for your post.

However it is not doing what I want (probably because I am not explaining it correctly as per Dave's post above)

I copied the code into the output sheet on my spreadsheet is that correct?

Also the thread title may be confusing (I think a moderator may have changed it).

Initally I start with two sets of data; A list of branch numbers which are listed in the Branches Tab and a list of products which are listed in the Data tab.

To create these on my ERP system I need to create a spreadsheet that contains a list of the items and in the first column enter the branch that I want the codes creating in.

Therefore if as in my sample I want to create the items in branches 02, 04 and 05 I need to create a spreadsheet that lists the items three times but in the first column it will include the branch number.

Thanks

Mark

Re: Repeat Rows By Mutiplying Current Amount Of Rows By Cell Value

Can anyone help with this?

Thanks

Re: Repeat Rows By Mutiplying Current Amount Of Rows By Cell Value

Please see sample attached.

The branches tab could contain up to 50 branches.

The Data tab could contain upto 50 columns

The output tab shows what I want to end up with

Thanks

Re: Repeat Rows By Mutiplying Current Amount Of Rows By Cell Value

Thanks for replying - Yes all in the same workbook as you describe

I will post an example later today

Hello,

I have a table which contains a list of branches eg;

01
02
04
06

I then have a spreadsheet which contains a number of columns and rows.

I want to create a new spreadsheet in the first column it will contain the branch from the table above then the rows and columns in the above spreadsheet

The rows and columns would then repeat for each of the other branches in the table. IE if I have 4 branches in my table and 100 rows in my spreadsheet my new spreadsheet would contain 400 rows

Thanks in advance

Markl

Re: Extract The Postcode From Text And Put In A New Field

Works perfect,

Thanks for your help

Markl

I have an access database which contains a UK postcode list (about 2 million records).

In an excel spreadsheet I have a list of addresses (about12, rows). I want to compare the list of addresses and if a postcode exists within the address which matches a postcode in the Access database then put this postcode in a seperate column and remove it from the address cell in the spreadsheet.

I have attached a small sample

Any assistance would be very much appreciated

Markl

Re: Reset All Filters To All

Thanks for the replies.

Andy's solution does exactly what I want

I have a spreadsheet with several columns with filters on each. This allows me to filter on several criteria.

Can anyone advise if there is a way to rest all filters to "All" without doing it one by one.

Thanks in advance.

markl

Re: Available Fields are Empty

I don't know if you still have this problem but I had the same issue and it drove me mad for months.

It actually turned out to be a problem with my Antivrus program (kaspersky)

Changes were made to the realtime protection level and everything works OK now.

Hope this helps

Markl

Re: sort text column by the the last words after the " - " digit.

I am sure that the VBA wizards on this site might have a better solution but I would convert text to columns using the "-" as delimiter. Then sort each column seperately

Markl

Re: Format Dates

Thanks Pangolin

But al this does is change the format so if for instance I created a pivot table to show sales by month, the row headers would show an entry for every date (e.g. 01/01/2006, 02/01/2006, 03/01/2006 etc) whereas I just want a total for January.

I am sure there are easier ways but I have found that the format above does the trick

Re: Format Dates

Bob,

I use the DATE Function:

=DATE(YEAR(B6),MONTH(B6),DAY("01"))

Assuming that the date is in B6. This function then makes the date the first of the month, you can then format it as you did before.

Hope this helps