Hi Everyone :)
I am experiencing an issue with a macro I created to help format some raw data sheets I have to deal with at work. The macro I have made is almost perfect, except I need the macro to detect the data range of the cells in use (as this changes with each RAW data file I receive) and...
I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly.
'Working in Excel 2000-2016
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
Dim OutApp As Object
Dim OutMail As Object
I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it.
In cell N6, I have =IF(C6="@",E6,0)
In cell N7, I have =IF(C7="@",E7,0)
Now if I insert an entire...
I am trying to create an automated report to be sent out as an email.
I need a email created and cells B6:S8 copied into a table and the email automatically sent from a PC.
I already have a Macro to take a back up of the information in cells B8:S8 and paste it into the next available...
ok, i'll explain as best I can
in d2:s2 I have week numbers
in a3:a100 I have part numbers
what I am looking to achieve is if I populate (as an example) h15
a formula in c15 will populate with the relevant week number from row 2
Hi - Could someone please give me bit of assistance, I am trying to get an excel document to auto resize to different monitor/screen sizes so bosses do not have to scroll around document. I have tried the code below but does not work (also not sure if putting in the right place, fairly new to...
Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ?
I have a range (b2:f2) that displays the weekdays of the week(Monday-Friday). In range(b1:f1) I have the dates corresponding with those weekdays of the week. Where I am located the current date is Saturday, the 5th day of October. Which is still considered the current week. So if I were to open...
This my first post, apologies if I break any rules in the forum.
I am trying to use VBA to write a simple code to auto fit column width. I have data in columns A:Z and I have also merged cells D5:J5. Naturally, I think a simple line like the following will do the job...
I need formula with if command in column E based on data from A to D, Secondary no Discount
Iam wondering if its possible to to code or do something with inputbox.
The thing i need. my costumer is going to put in a value of 7 numbers/letters, and then press Yes.
Is it possible to do the "yes" button automatic when 7 numbers/letters is filled in?
inputbox is appearing...
Hello All, I have a spreadsheet with some code for auto-population of cells, this requires the spreadsheet to be saved as "macro enabled". The problem I have is that the code cannot run in "Shared" mode. So I would like to add in some further code to automatically save then close the...
I have moved past the issue of time to decimal, as that was handled quite efficiently here. I am now on to a new "I need help" thing. I would like to have a yes or no question box pop up upon opening the worksheet (or workbook or speadsheet, not quite sure of that terminology yet) which changes...
I am trying to concatenate different columns from 2 sheets, which are in different order one to each other.
This would be the columns i need from the Auto sheet, and their counter from Manual sheet:
Can anyone tell me if it is possible, and how to enter multiple logic in the custom auto filter ?
For example, for a data set, I would like to filter between 7 AND 8, 8 AND 9 , 9 AND 10...and so on.
I have created a database for job lines in a plumbers that I work, for tracking new jobs. The database is completed using a data entry form to provide a new job number to a job.
I have also set up a blank job line that gets printed out to give to the engineer that is going to this job.
I set a formula adding the value of these 10 rows. Is it possible that if I do some sorting, lets say only 1,3,5,7 rows, is there an auto sum formula that will adjust automatically only summing those 4 rows?
Thanks a lot.
Could someone please help me with a problem I am having? I am trying to reference a cell in Sheet1 by using ='Sheet2'!A2 for example and carry it down to ='Sheet2'!A30, but when I insert a row between that range and type in information it doesn't auto update. Further...