Copying from one cell, into the next empty cell in column A in another workbook

Can anybody help me do this?

If its easier.
I am attempting to create a macro that will copy cell C4 from workbook 'Form' into the next empty cell in column A in workbook 'Master'

Does that make sense?

Any suggestions would be brilliant as the one i currently have doesnt work whatsoever

Regards,

Thanks.. But that doesnt really help me considering i need i to copy cell C4 from Wkbk 'Form' in 'Sheet1' and paste into Wkbk 'Master' Sheet 'July 08' in the next empty cell in a specific column.

I dont understand.. It says A4..?

Would it be possible to explain which bit does what..?
And does this paste it into the next empty cell in column A
Im not great with VBA if you haven't noticed.
In future i need to do it with multiple cells but im sure I can figure that out once i know what does what

Many thanks in advance!

I think that im in love with macros. And your macro.
Haha!

If that works..
You truly are a genius.. Seeing as our IT team just told us to click troubleshoot .. Great they are.

And in advance.. On behalf of my management team.. Thank you. (Only if it works.. Will let you know tomorrow evening after trying it at work)

I know its 20 to one and all that.

But this has been irritating me for weeks.

Will it matter if i change the data in cell c4 after running the macro?

I am getting a Compile Error: Sub or function not defined.???

Unfortunately i cant due to data protection.

Could it be due to the fact that it is a merged cell c4:e4?

Forgot to mention that.

In the suggested code Workbook("xy") shoud read Workbooks("xy")

Please Login or Register  to view this content.

The part that it is highlighting is the End With bit?

The strange thing is, my manager claims that this macro is perfectly fine on her computer at home, yet on the work computers it does not work!?

Any ideas guys?

Compile Error: Sub or function not defined

The workbooks definitely exist, I've had four people check the spelling and everything to ensure im not just being stupid.

There is a lookup so that only specific words can be entered into the column A but cell C4 contains info that is able to be enterred in there...?

Also do you need to have Master.xls or just Master?

It sucks really?
It doesnt seem to make any sense.

Will try that when im next in, thanks

The strange thing is, my manager claims that this macro is perfectly fine on her computer at home, yet on the work computers it does not work!?

Any ideas guys?

The problems may occur because of different settings in the Windows-Explorer (Menue: Extras > Options > show/hide File name extensions).

You should change the code by including the File extension .xls. Then it should work whatever setting is selected.
i.e. Workbooks("Master.xls")

When you say windows explorer, what exactly do you mean?

When you say windows explorer, what exactly do you mean?

Thats the program where you browse directories and files.

(c:\windows\explorer.exe)

You can select in options to show or hide file extensions (.xls, .doc, ...) of known file types.
If option 'show' is selected then in VBA workbooks must be referenced with file name and .xls extension. If option 'hide' is selected then the .xls extension is not required.