All,
I don't often have to use VBA so don't really know what I am doing however I seem to have come up with some code that works other than just continues to run. I can sort of see why it does this but was wondering if anyone could give me a point in the right direction.
The code enters a...
Hi all, hope that someone can help with this before my laptop takes the short way from the 9th floor;-)
Right I have a workbook called "Central Data" with 2 worksheets lets call them "Linked Data" and "Text Values"
"Linked Data" is sectioned into groups of 100 rows that link to other workbooks...
I hope an easy question to answer.
We have just been upgraded to Excel 2000 at work and I have noticed that when including a save or save as in a macro this is not recored.
The code is simply missing when editing the macro but it the code is manuall added it seems to work okay.
Is this a...
There might be another way of going about this but I am having a mental block.
I have a worksheet that contains data for five teams. The team is indicated by a column in the worksheet.
What I need to do is sepatate out and group each team data onto individual worksheets within the workbook...
Right, what I am trying to do is this.
Data is already in Excel.
I have 30 users that each process transactions that have their user name attached.
each user belongs to one of five teams.
I need a new column that shows the team that a user belongs to based on their name.
I have been...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.