Hi, first of all thank you for looking at this post.
I have started a new job and am wanting to improve the speedof the month end process.
I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
I have been looking for my original post or the post that I think I thought was mine but was someone else's.
Anyway, we have an access tool that someone else built. Each day I press a "Run All" button and 20 mins later I finishes and I continue. We are trying to have this run automatically a...
I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting?
A colleague has asked to see if there a way of creating a formula to calculate the progression that a group of young people have made through a survey folllowing a short course.
The table below shows 9 young people and where they gauged their level of understanding before and after the session...
Hello We use a product that generates an histogram on a PDF
I would like to generate a mirror image of the report but I also need help to generate an histogram graph.
How can I show you how the reports looks as I can't post images
I want to understand Developer-->Design mode and what is used for. I read this post
and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
I've written some code in VBA which creates a new tab based on a cell value. As you can imagine this cell value can change.
After creating this tab i wanted to paste some information into it. However, I cannot call the tab; i'm getting error 9 subscript out of range. Or Object required...
I have this sub from jmacleary found on this post
but i thought i would be best to start a new post as the problem has shifted
So the sub will grab sheets from an array and put the first column of each sheet into one sheet titled "Unknown"
My problem is that the sheets are now generated...
I've gotten a list of post codes and their counties.
This is how the data is presented:
#EAECF0[/URL] , align: center"]Postcode area
#EAECF0[/URL] , align: center"]Postcode districts
#EAECF0[/URL] , align: center"]Post town
#EAECF0[/URL] , align: center"]Former postal county...
Hi all, new to this forum. I tried to make a post about 4 hours ago but it will not show up in the Excel Questions forum. How long does it usually take for a moderator to approve it. I made myself look stupid by trying to post it twice more thinking I did something wrong the first two times.
I have a column of numbers :
I am trying to get the number of times the sum of two consecutive rows is below 3. In this example 4 (i.e. 2+1,1+0,2+0 and 0+2).
I tried a way around with this formula :
I am looking for a way to find the closest destination based on a post code entered by an user. As below, when an user inputs "Post code A", I would like the macro to use maps:) and bring back the closest location to post code A which for e.g may be Post code Y
Post code entered : Post...
I have replied to a thread i started last week, and it hasn't been posted, i did the first one about 11am AEST +10GMT and it worked fine, bu then i replied to another quote, i pressed submit, and had a meeting to go to.
I came out of the meeting an hour ago and checked the thread and the...
Can some body help me to split the excel value.
I have a list of address's in one excel and I want to split it into the normal address format.
for eg. my current value is something like this,
Abraham , XXX HOUSE, yyyy POST PLACE 689121
I want to split it like...
I'm stuck. I have a table where I want to read the dates depending on country and row type.
THEN - populate this on another table under the relevant date with a code.
So here's my table I am reading from (sorry I can't paste it as a table for some reason?)...