I have a spreadsheet of 300 rows of data. I need to insert a new row in between each row of data. Example insert a new blank row into rows 1,3,5 ect. Is there a way i can insert multiple rows into every other row without having to do each one separately.
View 1 Replies
Is it possible to move rows of data in a spreadsheet to multiple spreadsheet accordingly?
I had lists of tasks in a single spreadsheet and i need to segregate the tasks for all my staff in serial while no duplication among all of them. For instance, i got 4 personals in my department and i need the 1st 4 tasks to be distribute to each of them and next 4 tasks accordingly. This is due to all tasks are equip with due date and i need to calculate how much time i need to accomplishing them. i'm used to manually move it and found it time consuming, so i was wondering if someone would instruct me where or how to achieve it by using a simple macro.
Using excel's text to speech I've put together a basic spreadsheet.
[URL]
Code:
Function talkit(Speech)
Application.Speech.speak (Speech)
talkit = Speech
[Code]....
get the code for sending multiple emails as per the spreadsheet list. Assume the spreadsheet has 100 line items and each columns specifies the name of the person, value, recipient email address ("To" and "CC") and sender name.
And the Body of text is :
Hi "Name of the person" Please find the value of "Value" to be paid for the moth of xxx and kindly let me know for further clarification.
I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............
View 3 Replies View RelatedI have got a spreadsheet with many rows of data. One row is product name and the other is date written. Now I want to calculate how long these entries have been on the log. So lets say I have 10 entries called Pension all with different dates and 10 entries called ISA with different dates. So first I need it to look for all the proucts called "Pension" and then to work out how many are 0-3 weeks old and so on. So i want it to look like this but a formula to work it out for me and to update it automatically.
0-3 Weeks 4-6 Weeks 7-9 Weeks 10 Weeks +
Pension 4 3 3 1
ISA 3 4 1 2
(this does not display very well here but I hope you understand what I mean)
I am using Excel 2003 and I dont think it as a WEEKS function so I will do it in days and then devide by 7.
I know that to look for the product i use
=COUNTIF(H:H,"Pension")
The H:H is because the product is on colum H on my spreadsheet
I know to find the date it is
=TODAY()
So to work out something 3 weeks old it would be
=TODAY()-21
I have a spreadsheet that contains traffic count data for a two lane road. The data is by direction, by hour, 24 hours a day, 365 days a year so the data is basically 2X 365 = 730 rows of data.
I need to simply add the two directions together for each hour of each day, basically add two rows together, drop down to the next two rows and add them together, repeat.
I need the result as stand alone data on another spreadsheet so the Data, Subtotals operation provided by Excel won’t work for me but something similar that puts the data on another spreadsheet would work.
I also tried to use a formula in the new spreadsheet that added two cells in two rows on the original spreadsheet together and then repeated that process a few times and then tried to drag the formula down but couldn’t get it to repeat correctly.
I've got spreadsheet I use to control the inventory of my user equipment; who has it, what is it, where is it, etc.
I'd like to "lock" multiple consecutive cells of each row so that they never seperate. This is because they need to be together. However, periodically, I need to move, sort, or rearrange the sheet.
Is there a way I can "idiot proof" this so that these cells never come unlocked from each other?
There is no vba involved (primarily because I don't know how), and no other scripting either.
I have approx 150 rows on my spreadsheet, but I am having difficulty viewing the bottom rows. The slider bar on the right hand side actually disappears on the bottom of the page. I am using windows 8. changed the tool bars and that worked, but I want to see the tool bars.
View 2 Replies View RelatedI have a spreadsheet that has a range of a2 thru j62. I want to scan column B and if it is a 0, I want to hide the row and set the print area to the a2 thru j62 range and print the spreadsheet with the '0' columns hidden
View 2 Replies View RelatedI've a few rows that are hidden, and I cannot unhide them using the unhide function. The spreadsheet is not protected. What can I do?
View 5 Replies View RelatedI have a very large spreadsheet (about 50,000 rows, and to CM of columns) with blocks of data 20 rows high (rows 1-20 are from Building A, rows 21-40 are from Building B, etc). However, not every row in each block of 20 has information in it - some are just placeholders. For example, some blocks may have rows 1-18 filled with data while other blocks may have only 1-6 filled with data. I am interested in programming a macro that would delete the placeholder rows out of the spreadsheet based on a certain criteria. This would probably halve the size of my spreadsheet.
In faux-
For row i
i = 1 to 50,000
If Column B = #NA
Delete row i
Is this something that can be done with a macro, or do I need to go through all of these rows by hand? Obviously, I haven't programmed macros before (I've taken code and run it), but I've programmed in other languages (Java, C#). Could someone point me in the right direction?
Worksheet (Daily Sales) - daily input, copy to the worksheet (Weekly Sales), Monday through Saturday. The ranges copied are not consecutive. I am using If...then...else.
View 6 Replies View RelatedIs there a quick way to remove blank rows quickly. I have a spreadsheet with over 8500 rows but some are blank.
View 8 Replies View RelatedIs there an easy way to determine which rows in a spreadsheet are hidden, rather then scrolling through manually and trying to find nonsequential row numbers?
View 1 Replies View RelatedI've created the code below from scratch (ever so proud of myself even though it's basic lol)
Dim N As Long
Dim LR As Long
N = Range("A2").Value
LR = Application.WorksheetFunction.CountIf(Worksheets("Overview").Range("AJ:AJ"), N)
For N = 1 To LR
Here, 'N' is a project number. This code succesfuly counts the number of sub-tasks linked that that project in my data sheet. Now I want to bring all those rows into my template spreadsheet, but dont know how to start
How can I delete all blank rows in a spreadsheet without sorting the data as I want it to be in the exact order it is in.
View 5 Replies View RelatedI am making a template for my company to automatically calculate the amount of sheet metal needed for a specific job. The spreadsheet could get very long depending on how much duct is needed. Is there any way I can automatically insert rows to the end of the sheet by pressing enter after filling the last row with data, which would then move the totals down. Also, the formatting of the rows I wish to add need to be copies of the ones above.
View 3 Replies View RelatedI have a spreadsheet that is linked to another spreadsheet in a workbook. The information comes from an export of an access query into a template in excel that I am using just to store the values, then I link the values to the appropriate field in another sheet. I was wondering is there a way to programmatically hide blank rows in this sheet starting at a specific row of the page.
View 4 Replies View RelatedWe have a place where all our documents are stored. We have a log where we all log in what we're working on. Our trouble is, if one person has it opened nobody else can add their items to it. Is there anyway to have multiple people be able to open and enter their work for the day, save and close it out?
View 1 Replies View RelatedI've created a model that uses an add-in to calculate otherwise cumbersome formulas, and 4 or so people need to access this model at any given time. It's saved (along with the add-in) in a public folder on our network drive. Everyone is able to access the model, and is able to load the add-in directly from that folder, but the cells that use the add-in point to where the add-in is stored locally on my drive (C:Documents and SettingsmeApplication DataMicrosoftAddIns) and thus they are not able to use the add-in functions without redirecting every reference to me with references to their add-ins (basically just by finding and replacing every 'me' with 'them' in those cells at this point). So I guess what I'm wondering is how do I make it so the add-in is 'universal' (instead of local) such that as long as each user has the add-in loaded they can fire up the model and use the needed functions.
View 9 Replies View Relatedhow to highlight entire rows within a spreedsheet based on the information in a cell. I have gone to the conditional formatting and done:
=$A4="Needs Labs" and formatted that red, but when i go to note what areas it applies to, It will not highlight the row. I use the wizard box to decide where to apply the formatting like I saw on an online tutorial and dragged across the row, but nothing happened.
I would love to be able to limit the number of rows in a specific sheet so that I can quickly carry formulas to the bottom of a worksheet without carrying them to row 1,048,576. I'm aware of options to hide rows and/or to limit the scrolling with the "view code" option on the worksheet tab; however, I'm mainly worried about worksheet performance. When I carry a formula down, I don't want to see a spinning blue circle run for minutes at a time, and I'm hoping to avoid the same spinning circle when I undo my formula. Is there any way to actually limit the number of rows, or is there any other limitation I could put in that would increase worksheet performance?
View 1 Replies View RelatedI have data on Sheet2 and would like to only copy all rows associated with column D2 to the Sheet3. For example Sheet2 has two different values Voice or Data I would like to copy all rows associated with column D that contains voice to Sheet3.
View 4 Replies View RelatedI have a spreadsheet for a couple hundred rows of data, and 6 columns. The fifth column contains a date. What I need to figure out is this:for every 3 rows of data, if the date diffes in column 5 (E), highlight this row and the previous 2 rows
Currently, I've been doing this all manually, row by row - needless to say, it takes me a few hours or depending on how much other work I need to do, a few days.
I have to look through an entire table and find certain criteria (eg. "STEVE'S PIZZA SHOP"). It might be in columns G or H, or it could also be in Columns C or something of that nature. What I'd like to do is search through the table, find each instance of said criteria and cut each row the criteria apperas in to a different sheet. I'd like to do this as a macro, so I can set it up for other criteria as well. In addition, if I can include in the macro a way to create a header row (which I'm pretty confident I can myself), as well as change the title of the sheet the information is moved to. I have looked up Do-While loops, For-Next loops, If-Then loops. I am at a total loss.
View 9 Replies View RelatedI have about 7000 Excel files that I need condensed to one file. The data shown that I need in example one. In this example the data needed is in column B20 then B3-B19. My problem is the data in B20 is sometimes above or below.
In the other attached file(ExampleOutput) is how I am trying to get the data outputted.
Do you think that a macro/script con go thru all 7000 files automatically in a row to do this?
Is it possible to allow access to multiple users on one spreadsheet but they can only access one tab at a time each?
prevent multiple changes for the same thing.
I have a group of files on a network drive.
Directory is S:RailserveAvailability
The Excel files all start with Availability. After Availability is the date the file was created, followed by .xlsx So example, Availability041012.xlsx
The file has multiple worksheets, but work sheet names are the same in each file. I need data from the "Car Summary By Product Line"
The data from each sheet that I would like to get from each sheet starts in A4 through I4. There are forumlas in several of the cells so would need to be a Paste Special Values type copy.
So code/macro would do this:
Copy row A4:I4 from File Availability041012.xlsx, Worksheet "Car Summary By Product Line" to a row in the Master file
Then repeat for the next file Availability041212.xlsx (this data isn't typically generated on weekends so won't be a consistent date + 1) copied to the next row down on the Master file. This would allow me to chart data for car counts from day to day. It would be really cool to have the file date in Column J so I could chart by date and show a trend, but I know beggers can't be choosers.
I have roughly 200 days with multipule product lines so copying and pasting each one wouldn't be feesible.
I have a spreadsheet with multiple sheets, which can vary from project to
project, and they all have the same center sections of the headers. Is there
any way to automate the filling in of all these headers based on the first
sheet?
