spread

Sub saveworkbook() Sheets("Details").Select ActiveSheet.ExportAsFixedFormat Type:=xlsm, _ filename:="C:\Users\James\Documents\Excel Test Folder\Quotes Invoices Spread Sheets\_" & _ Worksheets("Details").Range("C6").Value & ".xlsm", _ OpenAfterPublish:=False End Sub

I am trying to "Squeeze" my text left to right and not reduce the point value. This is for a tag to engrave spread sheet. My engraving software will condense the text left to right and not reduce the height of the text. I need my spread sheet to do the same so my customer can see how the...

Hi, I'm trying to spread the cost of a resource between two dates. The start and finish dates vary and may fall within the same week or run across several months. I've managed to stumble across a formula I've found elsewhere and tweaked it to suit the format of my table but I'm struggling for...

I want take Pivot table total and divide it by count of days in the month and spread amount across by date. Here is example # of days count = 10 *** # of days count will change each week so the formula should adjust accordingly Amount = 5000 **** $50,000/10 should be...

I am trying to check some of the common email domain names when people enter them into an Excel Form. I have a spread sheet tab with names like gmail.com Comcast.net Hotmail.com etc Below is the code I am having problems with. I keep getting a Type Mismatch on this line

hi all, I am very new to VBA coding features . My company given me database spread sheet in which there are about more than 150000 lines in that sheet. So i need a user form to retrieve the data from the database spread sheet and edit the features and update the same in the field. I have...

I have a day date time cell in a spread sheet I am trying to reference but want to sum if that date = my cell on another spread sheet The cell on the other spread sheet is simply Nov-17. So I want it to match wher it is indeed from the relevant month regardless of day of month or time of day...

Hi, I'm trying to compare budget against actual against several cost codes. Part of the analysis requires me to look at hired equipment and I am required to compare spends vs budgets in weekly periods. I am trying (based on the anticipated or known on and off hire dates) to "spread" the...

Hi does any know a VBA Code that can send an email only not attached spread sheet with a addresses taken from my spread sheet under cells A1 and A2, subject “test” and message saying “please see below regards Mr X. Thank you

Hello, I blieve that I am using excel 2010 and I want to go off the edge of the spread sheet. I have a macro that interpolates a list of data that is 16223 rows long. The macro makes it aproximatily 5 times longer so aproximatly 82000 rows, but my spread sheet only goes up to 65536 and the...

i Have a excel spread sheet that is saved in Sharepoint. What I would like to do a black sheet within my spread sheet is have a running list of people’s name and date you opened up the file . Is there a VBA Code that can do this

I would like to press a button on my spread sheet and save the excel spread sheet to Sharepoint, does any one know a VBA Code to do this please

Does any one know how to send an email from a button on a spread sheet to an email address that is saved on the same spread sheet under cell A1 if any one could help please thank you

If B$2 is greater than or equals to today() and if $a2 is greater than 0 insert "Yes" other wise "No" I've a Google Sheet where you can spread your magic dust. Have you look here https://docs.google.com/spreadsheets/d/1ofGGVs0UBpWHMKhzlGdwIaOEm3VFd9qumZ9AWUmzLcw/edit#gid=0

Translator Spread sheet is not support Arabic Language 1-From Ar to Eng not OK 2-from En to Ar Ok Help PLS See Link Below https://www.mrexcel.com/forum/excel-questions/677976-translating-spreadsheet-7.html THX

Hi Team, I need your help here. 1. I have 2 spread sheet with some data in it which requires some filtering and formatting. i.e. in both spread sheet a) Delete row A1 to A12 b) Filter col CW and select only "Unprocessed" c) Filter Col CV and select text filter and choose contain "FX" d) copy...

Hi everyone, I'm struggling with a problem for quite some time now and haven't found a good solution for it yet. Already checked a lot of excel tutorials. I've made an excel workbook for all my expenses (and incomes) and made a pivot table to have a nice overview per month. But sometimes I...

Hi All I use an array formula that takes values that are spread out in a column and condenses the values in another column but it doesn't work with numbers. Example In column A there are 5 numbers spread out with spaces in between rows 1 thru 10. I need the first 5 rows in column B to show...

Hi I have a spread sheet that searches and lists information from another spread sheet based on 2 types of criteria and records which are vehicles at different locations . I want to put that vehicle information into another spread sheet under the respective location the vehicle works from...

Hi - I, want to create entry form in one sheet and data to be populated into another excel spread sheet(in the same workbook),pl suggest me. Thanks