Over 1 million tech questions and answers.

Solved: Excel 97 - want to automatically move data

Q: Solved: Excel 97 - want to automatically move data

Hi all,

I have a monthly report that has a certain column (always column BF) that contains the numbers 1-5, either singly or in any combination thereof. I have to copy this into 5 columns (BQ through BU) and I want those columns titled Q2 - 1, Q2 - 2, Q2 - 3, Q2 - 4 and Q2 - 5.
I need all the 1s in Q2 - 1, all the 2s in Q2 - 2 and so on.
Since the number of items in each cell varies, (there is no 1, , 3,4, , with blanks for non-existing numbers, rather one cell may have 2 and the one below it may have 1,3,5) is there a macro or a formula that would quickly copy every item into the right column?
It isn't vital, I suppose, I can copy, sort and cut and paste, but I would like to save the time....

Thanks in advance

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel 97 - want to automatically move data

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel 97 - want to automatically move data

Read other 9 answers
RELEVANCY SCORE 76

I work with Excel 2007. If under column A, I have 900 names of Restaurants, and under each name of restaurant, is a one-line address of the restaurant, what should be done so that the address can be moved to the cell to the right of the restaurant.

For example

This is the original data:

Column A
AAA Restaurant
AAA address
BBB Restaurant
BBB address
CCC Restaurant
CCC address
This is the desired result

Column A Column B
AAA Restaurant AAA address
BBB Restaurant BBB address
CCC Restaurant CCC address

Thanks is advance
 

A:Solved: Excel 2007 Move Data to Another Cell

Read other 7 answers
RELEVANCY SCORE 75.2

I'm a novice excel VBA macro user. I've manipulated already created macros, but I'm not sure how to create one from scratch. Can someone please help me create a macro.

I'd like to move the values highlighted in yellow to the cells highlighted in green...and then delete any rows that are empty.

Thanks in advance for the help.
 

A:Solved: Excel Macro to Move Data in rows to columns

Read other 9 answers
RELEVANCY SCORE 74.4

Hoping to get some help on this question please. I have reviewed the forum and found a similar post, but the sample data is more predictable than mine and the Macro posted doesn't work on my data. See post "Excel Macro to Move data in Rows to column" 28-Aug-2008, 05:47 AM".

On my data, I would like to be able to take the yellow row, and move the data up to the previous row starting in column "R". The rows I would like on the same line, all begin with a date. I don't know how to make a looping Macro that will identify the "date lines", and take the "second date line", and move it to the "first date line's" row.

Any help would be appreciated.
I have attached some sample data. (I hope that's okay?!)

Thank you!!!!
Christine

PS - The range on data varies.
 

A:Solved: Excel Macro to sort data by date, then move to new cell

Christine,

this macro below works well with the sample data.
Code:
Sub sorting()
Dim Rng As Range, c As Range, i As Long
Set Rng = Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers)
For Each c In Rng
i = (i + 1) Mod 2
If i = 0 Then
With c.Resize(, 15)
.Copy .Offset(-1, 17)
.ClearContents
End With
End If
Next
End Sub

How it works:
1. Takes all those cells in column A of the active sheet that contain numbers. (Dates are actually numbers, only formatted to look like dates.)
2. In a loop, it takes every second cell of the set of cells selected in Step #1.
3. Takes a 15 cells wide region starting with the cell selected in Step #2, and copies it to the region starting with the cell positioned one row up and 17 columns to the right.
4. Deletes the content of the original 15 cells wide region.

Caution:
1. If there are any numbers in column A besides dates, then the algorithm is wrong and the macro will fail.
2. If the dataset in the second date line is wider than 15 cells wide then the rest will remain in place. But the macro can be easily updated, just change the Resize line.
3. Don't run it twice on the same worksheet.
4. Always make a backup copy of your data before running the macro, because it is not Undo-able.

Jimmy
 

Read other 3 answers
RELEVANCY SCORE 74.4

I need to write a macro that will copy data from one spreadsheet into a separate spreadsheet (not in the same file). Here is the scenario...

On the first spreadsheet I have a customer's name in one column and a customer's address in another column. On a separate spreadsheet a have those same customer's names without the addresses. On the second spreadsheet the customer's name may be listed more than once. What I need to do is add the corresponding address to the second spreadsheet beside the name of the customer (identical data from both spreadsheets). The reason copy and paste won't work is because the customer may appear numerous times on the second spreadsheet and their are approximately 50,000 rows of data.

The macro needs to basically say IF Spreadsheet 1, Column A (customer) equals Spreadsheet 2, Column G (customer) then ADD/REPLACE info from Spreadsheet 1, Column B (address) to Spreadsheet 2, Column H (currently blank). I just can't figure out how to make it do that. ANY HELP ANYONE CAN GIVE IS APPRECIATED!
 

A:Solved: Need Help Writing a Macro for Excel to Move Data From One Spreadsheet to Anot

Read other 7 answers
RELEVANCY SCORE 73.6

Afternoon everyone!

I am trying to get a little bit of code working such that when a user enters in some data in column A, it triggers code in VBA to paint a simple surround black border over the whole row, from column A to M. Here is what I have so far, but it doesn't seem to be working. I know I am missing something (if not a lot).
Code:

Dim i As String

If ActiveCell.Column = 1 Then
If ActiveCell.Value <> "" Then
Range(Cells(i, 1),Cells(i, 13)).Borders.LineStyle = Excel.xlLineStyle.xlContinuous
Else
End
Else
End

I appreciate any help! Thank you in advance!
 

A:Solved: VBA in Excel: Automatically paint borders on data entry

Hi Maxx, you shouldn't forget to mention the version of Excel you're using

Place this code in the sheet
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <= 13 Then
If Target.Value <> "" Then
Range("A" & Target.Row & ":M" & Target.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Target.Offset(0, 1).Select
End If
End If
End Sub
 

Read other 2 answers
RELEVANCY SCORE 72

Hello my fellow databasers.

The Information:
I am currently working for a company that is tracking their part(s)
expenses per each customer job.

All customers' expenses are entered into the same 'primary' workbook so entering information is easier than going to each customer workbook. The column headings are as follows.

Customer Name - Date - Part Used - Cost - Invoice # - Additional Notes

There is 1 primary workbook and then each customer has their own workbook.

I have researched for a week now and am not savvy enough with Excel to know exactly what I should search for. I believe a macro is what I want though.
The question:
How, or what would I do, to have each workbook search for its relative 'Customer Name' and paste (auto populate) the information into the workbooks?

ex. I entered a part for John Doe within Primary Workbook. The second workbook sees John Doe, copies the row of all parts that have John Doe in the first column and populates it in the second workbook.

Also, would I need to create a separate Vlookup first to add a value to my customers so it wasn't text based to help the above equation work?
I know I could copy and paste each one, but sometimes we retroactively change values of costs, and for the amount of time I could save by creating ... a macro? or some formula would be well worth continued research. Any help is appreciated.

Application:

It's important for my employer to be able to see what parts were used ... Read more

A:Solved: Excel 2010: Macro or substitute to automatically copy data between workbooks

hi
A macro can do what you need but have you considered using filters on the primary workbook where you can select the customer name and only those records will be displayed? This will eliminate the need for multiple workbooks and make your life much simpler. An added benefit would be the ability to filter on other criteria like Date Or Part # so you can see across Customers what occurred on a specific date or which customers ordered a specific part.
Alternatively, this would be an ideal application for Access which would make data entry simpler and provide the information you need in the format you need.
 

Read other 2 answers
RELEVANCY SCORE 66.4

I have a need to move data from one worksheet that has an associated date to the correct spot in another worksheet with column that runs from 1/1 to 12/21.
Worksheet 2
1/1
1/2
1/3
1/4
...
12/31

Worksheet 1 has:
1/29 45
1/30 23
2/4 13
The macro would read the date in column A of worksheet 1 and put the data into the correct row of column B in worksheet 2. So that after running the macro worksheet 2 would look like this:

1/1
...
1/28
1/29 45
1/30 23
2/1
2/2
2/3
2/4 13
...
12/31

I hope my intention is clear and understandable.

Thanks in advance for any help,
tom
 

A:Excel Macro to move data into correct rom

Read other 8 answers
RELEVANCY SCORE 66

I have a excel file like below.

Column1 |Column2|Column3|Column4|Column5|Column6|Column7
Row 1 EEEE 1 2 3
Row 2 4 5 6

I want to move data in row 2 (4,5,6) to Row 1 columns 5,6,7.

Could you help me with an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.

your assistance is greatly appreciated.

thank you
 

A:Excel Macro to Move data in Rows to column

Read other 8 answers
RELEVANCY SCORE 66

If you check the file attached.

please can you help me in moving data with duplicate names to have the 2nd and 3rd email address moved to a new column and delete the row

need an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.
 

A:Excel Macro to Move data in Rows to column

I'm unable to understand the entire requirement, but for moving the records with duplicate names, I've written few lines. This will cut the duplicate record rows (Consider "Pupil Forename" for removing)from the "Report Data" and will post into "Sheet3". Before running this macro please insert "Sheet3". Let me know your requirement, hope I will be able to resolve it out. Thanks!

Code:
Sub test()
Sheets("Report Data").Select
Dim trow As Long
trow = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
For i = trow To 1 Step -1
If i = 1 Then
Exit Sub
End If
If Cells(i, 1).Value = Cells(i - 1, 1) Then
Rows(i).Select
Selection.Cut Destination:=Sheets("Sheet3").Range("A65536").End(xlUp)(2)
End If
Next i
End Sub
 

Read other 2 answers
RELEVANCY SCORE 66

I am looking for an application that can move large amounts of data from an Excel file to a Word document without me having to do ANY coding. I'm not a programmer.
In addition, I need a database to hold the data for future use.
Any input is appreciated as I am starting from ground zero.

Your comments and questions are welcomed.
 

A:An application to move large data from Excel to Word

Read other 6 answers
RELEVANCY SCORE 65.2

Hi,

I was hoping somone could please help me out.

I have an excel spread sheet with a lot of data in columns which i need to convert into rows. The problem is one column contains over 10,000 rows of data... thus making it too hard to transpose manually.

I have attached a copy of the spreadsheet (condensed version) and was hoping someone had some suggestions on how i can achieve my desired outcome.

Thanks very much,

Ray
 

A:Move alot of Data from Columns Excel 2010 - too big to transpose

I'm sorry to say that this is pretty much impossible as far as I can tell because there simply isn't enough consistency in your layout. If all rows were there and in order it would be easy enough.
As they aren't, one would need to inspect the titles to put them in the right place, but your titles don't always match either. For example your second "Telephone" entry is actually titled "Clinic Mobile", which the computer justly sees as very different indeed.
I'll try to help if I can, but you'll need some point of consistency if you want computers to automate a process. If it helps, here's a copy of my spreadsheet that inspects the titles (on sheet 2). If there are only a few problematic titles it might be easier to correct them manually (or use search and replace).
 

Read other 3 answers
RELEVANCY SCORE 65.2

Hello All,

I have an excel sheet which I want it to be converted to CSV and move that data from CSv to oracle databse. I have a Vbscript that converts excel to CSV but the way in which my excel sheet is formatted it is not coming up properly. There are some cells which I dont require and want them to be skipped and only the headings and their respective data should be coming up onto the CSV file. I am attaching the excel sheet and also the screenshots of that excel sheet showing the cells and the text needed to be skipped (highlighted in a red box). Please help me with this to have the CSV file by skipping these data and then load that data to oracle database in two tables where in one table will have data from some rows in CSV and another table will have a row of data from that CSV file.

Here is the VBscript that I have been using.
Code:

[COLOR=#2B91AF]WorkingDir[/COLOR][COLOR=#000000]=[/COLOR][COLOR=#800000]"C:\Users\vijaywp\Desktop"[/COLOR][COLOR=#2B91AF]Extension[/COLOR][COLOR=#000000]=[/COLOR][COLOR=#800000]".XLS"[/COLOR][COLOR=#2B91AF]Dim[/COLOR][COLOR=#000000] fso[/COLOR][COLOR=#000000],[/COLOR][COLOR=#000000] myFolder[/COLOR][COLOR=#000000],[/COLOR][COLOR=#000000] fileColl[/COLOR][COLOR=#000000],[/COLOR][COLOR=#000000] aFile[/COLOR][COLOR=#000000],[/COLOR][COLOR=#2B91AF]FileName[/COLOR][COLOR=#000000],[/COLOR][COLOR=#2B91AF]SaveName[/COLOR][COLOR=#2B91AF]Dim[/COLOR][COLOR=#000000] objExcel[/COLOR][COLOR=#000000],[/COLOR][COLOR=#000000]objWork... Read more

A:To convert an Excel file to CSV and then move that data from CSV to oracle database.

Read other 16 answers
RELEVANCY SCORE 64.8

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

Read other answers
RELEVANCY SCORE 64.8

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

Code:
[SIZE=2]Sub COPYIT()
'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Workbooks("Book11.xls").Activate
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Selection.Copy
Windows("Book10.xls").Activate
Sheet... Read more

Read other 3 answers
RELEVANCY SCORE 64.8

Hi Guys,

I've an excel sheet which has some data and I want that excel to be automatically mailed every month end to few mail ID's. How to acheive this ?

-santhu
 

A:Excel should mail its data everymonth end automatically

Read other 11 answers
RELEVANCY SCORE 63.6

I have a spreadsheet that connects to a database.
When I open the spreadsheet, I got asked if I wanted to refresh the data. I did so, and clicked yes.
Some time later, after getting bored ticking 'yes' every time I opened the sheet I ticked the 'don't ask me again' button.
Now every time I open a sheet that pulls data from a remote data source, it automatically connects and updates the data - I no longer want this to happen!!!!! Any way I can switch this off as easily as I switched it on????

andy
 

A:how do i stop EXCEL automatically updating from a remote data source?

hilight all live data and right click and select Data Range properties. Remove the tick from Enable Background Refresh. then ok then Save.
 

Read other 2 answers
RELEVANCY SCORE 63.6

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.
 

A:Solved: Access data export into Excel as the data linked to excel.

Read other 16 answers
RELEVANCY SCORE 61.6

Hi

I am looking to create some code to move a sheet from one file to a new excel file. SO the code needs to open a new excel workbook and place the required sheet in the resultant new file.

I have managed to do this with an existing file "Moved Pivot" per the code below. This is ok but other people will be using my sheet so the location needs to be chosen by them. A new file seems to be the only solution?

Workbooks.Open Filename:="C:\desktop\Optegra Installer\Moved Pivot.xls"

Dim oTargetSheet As Worksheet
Set oTargetSheet = Workbooks("Moved Pivot.xls").Worksheets(1)
Call ThisWorkbook.Worksheets("PIVOT_TB").Copy(oTargetSheet)
Set oTargetSheet = Nothing


Any help much appreciated. Thanks

Jeremy
 

A:Solved: Excel VBA to move worksheet to new excel file

Read other 8 answers
RELEVANCY SCORE 58.4

Someone I know recently had a PC break down, but the hard drive fortunately was left intact. They have since purchased a new one, however I have been entrusted with moving all the data, mainly photos from their hard drive onto a DVD for them. I think I know what I'm doing, but I have a nasty habit of running into these things without thinking them through. So I though I'd put a post here asking people what they thought would be the best way to do this task.
Thanks
Tubes
 

A:Solved: What is the best way to move data?

Read other 8 answers
RELEVANCY SCORE 58

Hello,

I have two problems:

1.
I have a lot of scanning data, all date and time stamped. All the scans show different status of shipped packages (all shipments have unique ID#, but there are multiple scans on route for all of them to track the packages). I want to find all the packages, for which there was "misdirected" scan, then for all of them, show the scan before. So, the end result would be all the scans that show for each package where it was misdirected (the terminal# of the scan before the misdirect scan).

2.
I want to automate this: run 5 queries every two hours between 8am and 10pm, copy and paste all results into Excel to specified areas (e.g. first query results to A1, second to A5000, third to A10000, etc. or onto different tabs), save as .csv to a specific folder, then send it as attachment to a given e-mail address. Even partial solution can be good.
I only know macros (somewhat), not as much VBA, so I tried that with the TransferSpreadsheet command, but can't get it work.

Any help is greatly appreciated.
 

A:Solved: ACCESS: Show second latest data and export data to excel from macro

Read other 14 answers
RELEVANCY SCORE 58

Excel 2003 SP3
Could anybody suggest a way, using whatever method you prefer to copy existing data to another tab, but have the data go transparent by 50%(or thereabouts, so you can just see it), but keep the headings normal font.
Thanks
 

A:Solved: Excel 2003 help to copy data to new tab and make data transparent

Read other 6 answers
RELEVANCY SCORE 58

When i export my inventory from my DB into an excel file, my trailer brands are listed as they are in my DB (of course). But when i bulk upload them with XML feed to trailer inventory sites (HTW.com & HTT.com for our example here). My inventory is listed on their site, but it's not searchable because the brand search is a drop down menu on these sites.

Say i goto HTW.com and do a search for 'Blue Ribbon' trailers none of my blue ribbon trailers show up because all of mine are listed as 'BLUE RIBBON TRAILERS, LTD' and the site is searching for 'Blue Ribbon' and although they are the same trailer brand HTW.com does not see them.

What i'm looking for is maybe a Macro or even formula that once i tell it what site i'm working on, will go through my list and replace all my spellings with the proper ones for that site...

Attached is an XLS file with 3 columns, the first is my list as is from my DB, the other 2 columns are the proper spelling for each corresponding site...

Excel's find and replace feature is a VERY crude fix to this, but since it's so time consuming it's NOT a viable solution.

Any takers??

Slurpee? Zack? Anyone??
 

A:Solved: Excel -Macro or Formula? Replace my data with similar required data - sample

for the record, a complete solution would be GREAT, but not necessary...
I just need someone to point me in the right direction and maybe a small working sample of like 5 brands and i'll expand the list from there...

cheers
 

Read other 3 answers
RELEVANCY SCORE 57.6

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

A:Solved: Excel macro to extract Word form data into Excel

Read other 7 answers
RELEVANCY SCORE 56.8

Please help ,

I have one sheet with headings,with 50 more sheets which include data,in data we have one emp code which is unique and more data for that emp.,format in all the sheets is same except the summary sheet(main sheet),what i want when i enter the Emp code in suumary sheet,the excel automatically search the data from subsquent sheet (basis emp code)and enter the data in next columns against emp code in summary sheet.

Regds
Mayank s
+919376914028,
 

A:Solved: Transfer of data from different excel to main excel

Read other 12 answers
RELEVANCY SCORE 56.8

I have been working with the same spreadsheet for a couple of weeks and have always been able to move around from cell to cell with my arrow keys. Suddenly I can't. The up and down arrow just scrolls the page and I can't go left to right. What is going on??

UPDATE: Never mind..I just found out what the Scroll Lock key is for!
 

A:Solved: Can't move with ARROW key in Excel

Read other 6 answers
RELEVANCY SCORE 56.4

i need to move 1tb of data to a 2tb drive...any idea fastest way?
 

A:Solved: what software to move large amounts of data

...richcopy.
 

Read other 3 answers
RELEVANCY SCORE 56

Hi there,
I know this question gets asked in various forms time and time again but I'm too much of a novice to make those solutions work for me.
I have a list of data but each item is spread over two rows making it unsortable.

ie
_ A B C D E F
1 a b _ _ _
2 _ c d e f g
3 a b _ _ _
4 _ c d e f g

b and c are both in colum B
whereas i would like to have

_ A B C D E F G
1 a b c d e f g
2
3 a b c d e f g
4

or even without the empty rows but even I can fix that.

If its not too much trouble I'd appreciate an explaination with any code so that I can try and change it for similar problems in the future.
I hope this is clear. I thank you very much for your time.
 

A:Solved: Macro to move excel cells

Read other 9 answers
RELEVANCY SCORE 56

Hey,

I have data on an excel sheet and I'm trying to find code that will move it from "Column A" to "Column B" using a special lookup of the word "Total".

Can anybody help me?
 

A:Solved: Excel: Find value and move it to next column

Read other 6 answers
RELEVANCY SCORE 56

Is there a macro that can be created to move the currently opened workbook to a different folder?
 

A:Solved: Excel Macro -> Move Workbook

Just issue the save as command to save the workbook to the new location with the same or new filename and then delete the old workbook

SAVE WITH NEW NAME
Code:
Sub MoveWorkbook()

vOriginal = ActiveWorkbook.FullName

ActiveWorkbook.SaveAs ("C:\NewName.xls")

Kill (vOriginal)

End Sub
SAVE TO NEW LOCATION WITH SAME NAME
Code:
Sub MoveWorkbook()

vOriginal = ActiveWorkbook.FullName
vWB = ActiveWorkbook.Name

ActiveWorkbook.SaveAs ("C:\NewFolder\" & vWB & ".xls")

Kill (vOriginal)

End Sub
Regards,
Rollin
 

Read other 3 answers
RELEVANCY SCORE 55.6

I have a flat file that when I read it into excel it populates column 1 of each row with data.
This data is actually a series of 5 fields that I need to have in columns and rows, that is,
column a1 thru a5 I need placed in a1, b1,c1,d1 and e1 followed by
column a6 thru a10 placed in a2,b2,c2,d2 and e2.
The data is balanced, that ism there is data in each of the 5 fields for a "record".
Any help would be appreciated.
THanks
 

A:Solved: excel macro to move columns to rows

Read other 8 answers
RELEVANCY SCORE 55.2

Excel is automatically saving documents as a pdf. When I click save as the document says excel spreadsheet but when the document is saved it is a pdf. Please help.
 

A:Solved: excel automatically saving as pdf

Read other 7 answers
RELEVANCY SCORE 54.4

I have a rather large file that I would like to print. I have other files like it that were done in Excel and they came out just like I wanted them to. The entries are arranged in rows and columns. I was able to number the rows and put headers over each column. The one in question is arranged in rows but not in columns. I can open it in Excel but I have no idea how to get it to arrange into columns. Is there any way Excel can do this for me? I'd really rather not do this manually because there are over three thousand rows that need to be in 12 columns.
 

A:Solved: Can Excel automatically arrange columns for me?

Read other 13 answers
RELEVANCY SCORE 54.4

I have the follow code behind the ThisWorkbook_Open Event:
Code:

If Weekday(Date, 1) = 6 Then
'Do nothing
Else
ThisWorkbook.Close
End If

Is this the best way to perform this operation?

Also, if the day was not yet Friday, how would I keep the workbook from closing if I needed to open it for modifications?
 

A:Solved: Excel VBA Automatically Close Workbook

Read other 8 answers
RELEVANCY SCORE 54.4

Hi, I am trying to automatically have sorted in excel 2 columns in sheet 2 with data linked with sheet 1 so that when you enter data in sheet 1, the data in sheet 2 is being automatically sorted.

My data on sheet 2 are in 2 columns: Project ID and Score. The data are in cells B2 to B101 and C2 to C101.

The data in sheet 2 are linked to data on sheet 1. The "project ID" column (B2 to B101) of sheet 2 is linked to cells D8 to CY8 and the "score columns (C2 to C101) of sheet 2 is linked to cells D79 to CY79.

The idea is that when score is entered in sheet 1, the project ID and score of sheet 2 gets automatically sorted so that we see at the top which project has the highest ranking.

Can someone help me out with the code to use? I am a beginner...

Thank you!!

ps: it is quite urgent
 

A:Solved: automatically sorting in excel 2003

Read other 16 answers
RELEVANCY SCORE 54.4

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

151
183
2001

results = "151","183","2001"
 

A:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

http://www.asap-utilities.com/

(edit: "entire column" -- do you mean full from top to bottom? )
 

Read other 2 answers
RELEVANCY SCORE 54

Customer wants to retain db data for 60 days and as per sizing tool 12 tb of data needs to be retain? Customer limitation is they have only 2 tb of SAN drive size and do not want to go to windows stripping. 
Is there an option to hold 2 weeks of data on the Mongo DB in ATA Center and move older data in some other format to the NAS drive?
or if there is any other option which can be used? 

Read other answers
RELEVANCY SCORE 54

Hi,
Does anyone know how to automatically create and open graphs in excel from a form in access? Someone suggested writing a query that would autoatically graph in excel and using the docmd.outputto command to output the graph to excel, I 'm not entirely sure how this works and or what query to write that would automatically do the graphs for me in excel. Please help!

Any help will be greatly appreciated
 

A:Solved: Access to automatically open graphs in Excel?

You can graph it in Excel, but you can also graph it in Access as well.
 

Read other 2 answers
RELEVANCY SCORE 54

Hi, I have approx 25,000 rows of data relating to parts held in inventory, on a spreadsheet in Excel 2003 SP2 .

One common cell on each line is the Supplier Stock Code and the data in it is duplicated on different rows as the same Supplier Part is held under several different Part ID's on our system, ie,

Cell A2 0-320311-00
Cell A3 0-320311-00
Cell A4 0-320311-00
Cell A5 0-330317-29
Cell A6 0-330317-29
Cell A7 0-330317-29
Cell A8 03400BK08345
Cell A9 03400BK08345
Cell A10 03400BK08345
Cell A11 03400BK08345

I have sorted the data into Supplier Stock Code order and need to find a way to automatically insert a blank row (or two) after each change, ie, in the example above it would be between rows 4 & 5, and 7 & 8.

Does anyone know of a Macro which will do this?

Many thanks,

MarG38
 

A:Solved: Excel Macro to automatically insert rows

First things first -- welcome to the board.

2nd thing:

"insert a blank row (or two) after each change"

Hmm: for what purpose? The "official" line is "DON'T do that, it's VERY bad design". K?

So what I did was drag your last entry down to r25000, to generate 03400BK08346,
03400BK08347, and so on. "Test data".

Then I ran the code at the bottom of this post. It ground away for 12 minutes (make coffee, visit bathroom, yada yada) & then fell over on account of "ran out of worksheet" (bear in mind I had c.25K unique values, you have far fewer).

Last (but most definitely not least) thing: back up your work before trying the code.

HTH

Sub test()
Application.ScreenUpdating = False
LastVal = Range("A" & Rows.Count).End(xlUp)

Do Until LV2 = 1
x = Range("A" & Rows.Count).End(xlUp).Row
x = Range("A" & x).End(xlUp).Row

If Cells(x, 1) = LastVal Then
LV2 = 1
Else
y = Application.Match(Cells(x, 1), Columns(1), 0)
z = WorksheetFunction.CountIf(Columns(1), Cells(x, 1))
Cells(y + z, 1).Resize(2).EntireRow.Insert
End If
Loop

Application.ScreenUpdating = True
End Sub
 

Read other 2 answers
RELEVANCY SCORE 54

Can anyone help?

I've been asked to look at an excel file at work and they want a button that when clicked will put a new row at the bottom of the current records (i.e. the next empty row) and autopopulates the first cell in the row with a unique number (preferably sequential) so this can be used as an identifier for that particular record.

any help would be greatly appreciated!
 

A:Solved: excel macro new record that is automatically numbered

Read other 16 answers
RELEVANCY SCORE 53.6

Is it possible to link an Excel and a Word file so that a change in Excel would automatically occur in Word?

I have a membership roster in Excel and I'd like to have a mailing label file that would automatically be changed when I add or delete names in the Excel roster. (Going through the whole mail merge process is cumbersome.)

I've tried searching the Help files, but it refers to embedded objects and such and I don't think that's the way to go with this.

Thanks for any help!!!
 

A:Solved. Linking Excel list to automatically update Word

Read other 8 answers
RELEVANCY SCORE 53.6

Hi,

I have multiple Excelsheets where in I use it for day today activites & tracking.
I have attached one of the simple one so that I can know the codes for sending mails & I can do it my self for the rest of the workbooks.

There is a sheet(dash board) where in all the details get updated.
When there are any changes to the value in column F, a mail should automatically sent to me giving the detials of the row. The file will be always live in the server.

I am very poor in coding & I need someone to help me in doing this.

Thanks in advance.
Rgds
Ganesh Hassan
 

A:Solved: Automatically send email from Excel based on the conditions

Read other 8 answers
RELEVANCY SCORE 52

I want to get some data out of a cel in Excel

I did try the following code ( but didn't get any data out of the cel), in my case it is an existing excelsheet :

Example,

DimappAsMicrosoft.Office.Interop.Excel._Application;
DimwbAsMicrosoft.Office.Interop.Excel._Workbook;
DimwsAsMicrosoft.Office.Interop.Excel._WorkSheet;
DimtemplateAsMicrosoft.Office.Interop.Excel.XlWBATemplate;
app = New Microsoft.Office.Interop.Excel.Application();

template = Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet;

wb = app.Workbooks.Add(template);ws = wb.ActiveSheet;
ws.get_Range("A1", "A1").Value2 = 1000;
ws.get_Range("A2", "A2").Value2 = 1000;
ws.get_Range("A3", "A3").Value2 = "=A1+A2";
LogMessage(ws.get_Range("A3", "A3").Value.ToString());
wb.Close(False, Null, Null);

app.Quit();

Later today i found this code too that should open ( i think)an excel sheet, so i only still need to read the correct sheet and cel.

Dimwb2AsMicrosoft.Office.Interop.Excel.Workbooks;
'Open( Filename, UpdateLinks, ReadOnly, Format, Password,
'WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter,
'Editable, Notify, Converter, AddToMru, Local, CorruptLoad );

WB2.Open( "C:\knmi.xlsx",
"", "", "", "",
"", "", "", "",
"", "", "", "",
""... Read more

A:Solved: Getting Data out of Excel

Read other 11 answers
RELEVANCY SCORE 51.6

Hello, I have a table set up in Excel, the first column is a column of six digit numbers used to identify a product in our company. The next six columns contain information about that product. I also have an SQL database that I use from Access. I extract the data from the database either by copying it or by using the Access On-line collaboration process. My problem is the same six digit number I use from the database is not recognized in Excel when I do a Vlookup on my existing table. One quirky detail is that if I go to a cell containing the number from the database and edit it (hit F2) make no changes and hit enter, the Vlookup function then recognizes it and extracts the data from my table. I have tried reformatting the cells. I have used the "clean" function, the "right" function, and even "concatenate" with another blank cell. Nothing works exept edit - enter. Any ideas???
Thanks
 

A:Solved: Data from Access to Excel

Read other 6 answers
RELEVANCY SCORE 51.6

I need to find an easy way to sort and sum tabulated data.
Specifically, one collumn contains company names, and another individual transaction values, so some customers are represented several times.
I have sorted the data but would like to find an easy way to sum up the total value of transactions for each customer, which means finding a way to identify and group them. There are too many to do manually, and I am not conversant enough with all of the functions to know how to do it.

Any ideas?

Using excel2003.

thanxx
 

A:Solved: excel - how to sum common data?

Read other 10 answers
RELEVANCY SCORE 51.6

Guys,

I have a MS Excel workbook containing a number of sheets of data. The sheets keep a record of various documents received into a department for review. Currently, there are about 1000+ document references (rows) in each sheet. Each sheet has 27 columns of info, of which column “I” holds the date that the document was received into the department.

I can do a data sort on the sheet for column “I” so that it is in ascending order. What I need to do, is to be able to enter a “Start Date” and an “End date” into cells in another sheet, then push a button that will run a macro, resulting in my records sheet only displaying rows of info between those dates (in fact, deleting all rows that are not within the start and end date). How do I get the code whereby it looks at the value in column “I”, if it within the start and end date, leaves it, if not, then it deletes the entire row.

Your help would be very much appreciated!!
 

A:Solved: MS Excel data sort.

Read other 11 answers