thethinker

How do I do this? I understand that there's Spotify/Itunes etc etc but I have loads of rare vinyl that I own and have converted to mp3. I want to upload this to a server then be able to stream it wherever I am in the world. Does anyone know if this is possible, I cannot find any info on it at all? Thanks

Hi, I have a great Word template that I used for huge client audits, the only thing is, I use data from Excel/CSV files then have to copy and paste it to Word. I then PDF my Word template and all is good!

I was wondering - is there anyway I can dynamically insert text/numbers into Word from CSV or Microsoft Excel? This would really help me save some time. Any suggestions would be great.

Thanks

Hi, I have been scratching my head with this one for ages! How do I put the colums on top of each other so that I get 3 entries of "MAIN!A13" on top of each other [AS THEY ARE NOW) then the "MAIN!A14" colums below theses ones, then the "MAIN!A15" ones etc. Here's how they look now:

MAIN!A13 MAIN!A14 MAIN!A15 MAIN!A16

MAIN!A13 MAIN!A14 MAIN!A15 MAIN!A16

MAIN!A13 MAIN!A14 MAIN!A15 MAIN!A16

I want this to look like:

MAIN!A13

MAIN!A13

MAIN!A13

MAIN!A14

MAIN!A14

MAIN!A14

MAIN!A15

MAIN!A15

MAIN!A15

MAIN!A16

MAIN!A16

MAIN!A16

Of course, I have many more than this to do! Any help would be appreciated. Thanks.

I have never studied economics but understand the basics. There's always talk of entrepreneurs 'creating wealth' How does this work?

Scenario 1

If I open a shop selling socks, then I employ 3 people, we all make some money, 3 people get jobs etc. I understand that. However, that money has only shifted away from another sock shop, so has anything really been created? Haven't we just 'redistributed wealth'?

Scenario 2

We find a load of gold in a mine so employ 100 people who were previously unemployed. So 100 jobs have actually been created seemingly from the earth's resources. So we sell the gold, whoever was selling gold before me now loses out? So haven't we redistributed wealth again?

I understand the concept of supply and demand so how does that fit in as well. The more gold around, the cheaper it should become. Of course, investors may turn to it when other options aren't looking too good which will affect price but...

Can anyone explain in simple terms if wealth can actually be created and if so how?

I appreciate people have studied this type of thing for years, so apologies if these questions are basics..Just wanted a human answer rather than hours of sifting through websites.

I've created a macro and need to now run multiple sheets through this. Does anyone have a clue how to do this. For example, I have this array where BE.xls is the first sheet. I have another 20 sheets with different names but don't really want to copy and paste this whole macro 20 times, I just want to say: 'please loop through, BE.xls, AT.xls, UK.xls and so on. This is a lot easier in case I add or remove any sheets. Does anyone know the code to do this at all? Thanks in advance for any help.

Windows("BE.xls").Activate

Columns("C:C").Select

Selection.Delete Shift:=xlToLeft

Columns("D:E").Select

Selection.Delete Shift:=xlToLeft

Selection.Replace What:="0", Replacement:="-", LookAt:=xlWhole, _

SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

ReplaceFormat:=False

ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort.SortFields.Clear

ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort.SortFields.Add _

Key:=Range("D2:D45"), SortOn:=xlSortOnValues, Order:=xlAscending, _

DataOption:=xlSortNormal

With ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort

.Header = xlYes

.MatchCase = False

.Orientation = xlTopToBottom

.SortMethod = xlPinYin

.Apply

End With

I was wondering if there was a macro or formula that can look at cells and remove any that contain contain the same keywords but in a different order. For example if I have 100 rows and 4 of them are:

scotland budget hotels

budget hotels scotland

hotels budget scotland

I only need 1 of these to remain - not a huge preference which. Is there a way to say:

'look in these rows for any duplicates then only leave one' There could be other cells that have only two words but the same problem:

cars red

red cars

Again, I would want to leave one of these and delete the other. If anyone can help with this, I'd be really grateful.

Hello!

I have my page.tpl.php with a standard h1 tag:

<h1><?php print $title ?></h1>

All is well with the world, however, I want to use an image to style my H1 tags with a specific font. This is all very well but these main pages are all unique so I need to add a class to the h1 tag so that all my main section h1 images are unique.

My thoughts are using php to grab something unique on each main page to make up a unique class id...the URL is unique so I grab that:

<div class="<?php print $current_path = drupal_get_path_alias($_GET["q"]);?>"><h1><?php print $title ?></h1></div>

This works fine and I don't even know php so I think I've cracked it! BUT!! Some of my URLs have numbers in them, they are printed/rendered fine in the page code but the css will not communicate with them.

So this one is fine:

<div class="books-and-toys"><h1><?php print $title ?></h1></div>

However, this will not style:

<div class="70s-books-and-toys"><h1><?php print $title ?></h1></div>

So, does anyone know how I can get round this, or indeed, anything else that is unique about my pages so that I can print something to make up the unique div id?

Many thanks for any help in advance

Another Macro question! I have a workbook full of sheets. In each sheet there is a keyword in cell A1, this is standard on ALL sheets. I want a macro to 'look' at cell A1 in a workbook, check all cells in column A for any instance of this keyword, then delete any cells that it is not found in. Then move onto the next workbook and perform the same action.

Example:

Workbook 1 has the folliwing words in starting from cell A1 to A5:

A1 shoes

A2 red shoes

A3 blue clogs

A4 shoes for men

A5 ladies handbags

So I want the macro to use cell A1 to grab the keyword, in this case it is 'shoes' then I want it to delete all cells that do not contain this word, so A3 and A5 would be deleted. Then I want it to move onto the next sheet in the workbook and do exactly the same!

Might be a big ask but if anyone can supply me with the code for this I'd be grateful.

I have looked at so many posts but still cannot work out how to do this!! I simply want to delete column B from each sheet in my workbook. Can anyone supply me me with full working code for this please, I'd be very grateful. This is my current code for when I performed the action on the first 2 sheets, I just can't seem to adapt it. I just want to say:

Perform this - Columns("B:B").Select

Selection.Delete Shift:=xlToLeft

On EVERY sheet found in the workbook.

Am I stupid or is this really complex?

Sub DeleteColumnB()

'

' DeleteColumnB Macro

'

'

Columns("B:B").Select

Selection.Delete Shift:=xlToLeft

Sheets("Sheet1").Select

Columns("B:B").Select

Selection.Delete Shift:=xlToLeft

Sheets("Sheet2").Select

Columns("B:B").Select

Selection.Delete Shift:=xlToLeft

End Sub

I have this macro:

Windows("Germany.xls").Activate

Columns("C:C").Select

Selection.Delete Shift:=xlToLeft

Columns("D:E").Select

Selection.Delete Shift:=xlToLeft

Selection.Replace What:="0", Replacement:="-", LookAt:=xlWhole, _

SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

ReplaceFormat:=False

ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort.SortFields.Clear

ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort.SortFields.Add _

Key:=Range("D2:D45"), SortOn:=xlSortOnValues, Order:=xlAscending, _

DataOption:=xlSortNormal

With ActiveWorkbook.Worksheets("Page position 1").AutoFilter.Sort

.Header = xlYes

.MatchCase = False

.Orientation = xlTopToBottom

.SortMethod = xlPinYin

.Apply

End With

I can change the "Germany.xls" for a different country each time and copy and paste and all is good. But, can't I just say:

Germany.xls,France.xls.Spain.xls Then paste the macro once so it runs it on all sheets? Is there a simple way to do this, or am I best just copying and pasting the macro and changing the file names each time - seems long winded to me! Any help appreciated.

Hi, I got a macro which works fine on numermous sheets, as you can see, it is the same action but performed on a different Excel sheet, in this case they are countries. The only thing is, it is the same action for each country so my Macro is quite long and if I need a change to one I got to do them all, is there a simple way of adding my countries to an array and then runnning just one block of code that gets used on each sheet, would make life a little easier. I'd be grateful for any help!

MACRO:

Windows("USA.xls").Activate

Sheets("Worksheet").Select

Sheets("Worksheet").Name = "USA.xls"

Range("A29").Select

Sheets("USA.xls").Select

Sheets("USA.xls").Move Before:=Workbooks( _

"AllWebtrends.xlsx").Sheets(1)

Windows("UK.xls").Activate

Sheets("Worksheet").Select

Sheets("Worksheet").Name = "UK.xls"

Range("A29").Select

Sheets("UK.xls").Select

Sheets("UK.xls").Move Before:=Workbooks( _

"AllWebtrends.xlsx").Sheets(1)

I need a formula that checks out 3 details then returns the number in the cell that if finds.

I have 3 subheadings at the top of my sheet, these are merged cells and contain 'q1' 'q2' and 'q3' headings. I then have single cell headings under these with 5 variables, let's say colours, yellow, red, blue, orange, grey

On the left hand side column (A) are differrent countries listed in A1, A2, A3

Now I need to 'tell' Excel to search for:

the quarter I specify 'Q1'

the country I specify 'USA'

the color I specify 'yellow'

then return the number that is in that cell.

So I am saying, 'look for 'q1' in the top row, look within these cells, for the country on the left that I specify, now tell me what the number is in that cell.

The reason this is a little difficult is that the colors are repeated throughout the sheet more than once as there are different quarters of course. Each quarter title is a merged cell with the corresponding name in it, wondering if I can tell Excel only to look within these guidelines..Any help appreicated!

I need to select 4 unique words from a list of 20. I don't want any repeats in each set of 4. So I will end up with 100 rows of sets of 4 words - each row will not have any duplicates within the 4 words.

Anyone any idea how to do this?

Thanks in advance for any help.

I've been looking at this stuff for hours. I have added a custom field in my back end editor and it works perfectly. I now need to print or echo the result from this new field into my <title> tag on my template. Sounds easy...well it's not! I can add this to my templates no problem within the html page by using:

<?php echo $this->escape($this->article->mynewfield); ?>

But I cannot get this to work within this code which is where the head tag is picked up from:

$document->setTitle($document->getTitle() .' | '. str_replace('&', '&', $mainframe->getCfg('sitename')));

I want to add my variable to this so that whatever I type in my new field when I create an article goes between these two tags:

<title>Article Name H1 | My New Field Text | Sitename

Does anyone have any idea how I get my variable into here, I've tried everything. Thanks in advance for any help.

Well this one has me scratching my head. I have 200 rows of data each row has 5 cells that have numbers placed in them. I want to grab the numbers from these rows and place them into columns. The numbers refer to something else, so need to be as they are - not added up or anything.

Anyone have idea how I can do this, or if there's some kind of formula?

Thanks in advance.

p.s. example would be cell A1 is 'Madonna - True Blue' cell B1 = 3, cell C1 = 5, cell D1 = 8

I now want to start a column with 'Madonna - True Blue' at the top - A1, then underneath would be

A2 = 3

A3 = 5

A4 = 8

I have cells in one Excel sheet that are referencing another sheet. example, these start at cell A1 and move across the sheet to A3:

A1 B1 C1

=SCORECARD!H21 =SCORECARD!O21 =SCORECARD!V21

How do I continue dragging this to the right so that the formula recognises that I want to continue this sequence?

For example the next cell (D1) that is dragged needs to contain: =SCORECARD!AC21

As this is grabbing every 7th cell on the other sheet.

So E1 would be =SCORECARD!AJ21 and so on and so forth. So how do I tell Excel to do this! Any help would be really appreciated.

Hi, I've now spent 2 hours trying to do this. Does anyone know how to convert multiple rows to multiple columns? I have data starting in A1 all the way to I1 and multiple rows underneath it. I want each row to be a column. I'd be grateful if someone could help, but I might need to send you the sheet! I've had no luck copying the ones from the internet. Thanks in advance for any help.

I've been trying for weeks, literally, to rename these URLs and also ensure the old one is 301 redirected to the new one:

www.example.com/?mod=11&p=215 - www.example.com/clean-url-section

www.example.com/?mod=96&tab=6 - www.example.com/clean-url-section-2

Does anyone have any idea why I am having no luck, I got 500 server errors or nothing at all! Is it because of the question marks and characters? I'd be grateful for any help.

I already have modrewrite on my Apache server and my URLs are clean already - www.example.com/this-is-my-url

I now need to 301 redirect all old URLs to new URLs after rebuilsing a site but it simply won't work! These have already been rewritten so this makes the process even more difficult, there seems to be not a shred of information on the internet on how to do this. For example, I want to redirect:

www.example.com/this-clean-url to this:

www.example.com/this-new-clean-url

It won't work in the conventional way, as the one to be redirected already has stuff applied to it to rewrite, I think..

Has anyone out there ever actually done this and can help by any chance? Thanks in advance.

I want to provide a client with some simple html to place within a div on their website. I want this to contain a URL that points at a file that I can then change remotely. This file needs to place text on their website that can be crawled by Google so cannot be an Iframe. I am rather a novice so could do with a full example! Thanks.