Thanks for letting me know
Type: Posts; User: HowardC; Keyword(s):
Thanks for letting me know
I had an attachment reminder for Outlook "Code 2 Outlook attachment reminder"
It worked perfectly for Office 2010, but I recently upgraded to Office 2013 and when selecting the send button on...
Thanks for the reply.
The descriptions are already on the Consolidation sheet and just the values need to be carried over
Where the following appears under Dept1 for the first time , would it be possible to write code to insert the description "RETAIL SALES/EXPORT-SUMMARY" next to each of these in Col A....
Thanks for the help Maude
Where the decriptions are unique to a particular sheet for eg BR2 the values must also be copied to the consolidated sheet
For example Units Sold
Thanks for the reply Steve. I will import Trial balances where the account numbers are exactly the same and then set up a standard management report
Thanks for the reply, Steve
Looking at your points 1 - 4, I now see that this is going to cause a huge problem
There may be a way to resolve this. If there is a way to extract unique...
What I mean by consolidate is to combine the values where the descriptions are the same in a given Range for Eg Dept 1 ranges from 1 to 125
For eg I would like to add the values for...
Attached please find sample data where I would like to consolidate the values on sheet Br1 & BR2 (Cols F & H) where the text in Col B is the same by department.
I also need a macro to clear the...
My apologies. I must have deleted the macro in error
I managed to sort out an error in my code.
In my code I had
Hi RG & Steve
It would be appreciated if one of you can assist me in getting the macro "Delete_next_period" to work. If I delete this macro, then the other macros in the workbook can be run
Thanks for the reply
I have filtered data that is imported on sheet "Data". I manually filter the data for a specific month number in Col O for Eg 10 and then delete these rows. I then refilter...
When trying to activate any of the macro on the attached workbook I get a message regarding macro security (has also attached screen print of message)
I have look at my macro security settings and...
Thanks for the help, much appreciated
In the text box containing the cost (Txtcost), I would like the code amended, so that if there is a xzero after the decimal pace for eg 7040.00 and the user enters 7040, the code will...
Thanks for the advise. Will Try this
Thanks for the info Martin
From time one uses Ctl C to copy, it does not always copy and one needs to rerpeat the process
Is this an intermittent Microsoft problem?
It does not happen often -only every now and then
I overlooked this (Dim I as Integer). Have tested and code works perfectly
Once again thanks for all the help
Thanks for your help. I am getting closer to the desired result.
After entering the data and selecting "Add Fixed Assets" , I get a message "compile error variable not defined and the...
Thanks for all the help Maude
I will get back to you tomorrow as I need to test the code this evening (it is 14:48pm over here)
Thanks for the help
I have a Template was a user form which is activated on sheet "Macro"
The user form copies the data into the vrespective fields once "add Fixed assets" is selected.
I would like to amend the...
I have a macro that clears data on all sheets , except the first and last sheet .
The following are the exceptions :
1) It must not clear text for Eg Oct 2013, Man etc
2) Where a value...
Thanks for the reply. Hope you have made a full recovery. I overlooked your reply. It works perfectly