Hot Downloads



The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Microsoft Excel

Microsoft Excel 9 years 10 months ago #30491

Hi Folks,

I've got a bit of a problem which I hope you guys can help with. This may get a bit complicated, so apologies in advance :D

I've working on a little report spreadsheet, and want to do the following: I want to automatically copy data from one spreadsheet to the other, then delete the original data. Now, so far, I've managed to write a little formula to move the data over from one sheet to the other, but don't know how to make it delete the original data.

Does anyone know if this is possible, and if so, how do I do it?



Re: Microsoft Excel 9 years 10 months ago #30492

Hi Rockape,

I think you can do it with Macros, just record the tasks (cut/paste) and you are done.
Now you have to schedule this macro to run every x minutes.
Hope this helps.

always Face your Fears...

Re: Microsoft Excel 9 years 10 months ago #30493

Hi Alans,

Thanks for that, I thought I might have to go down the Macro route. The problem is, what I'm trying to do, is make the changes when a state change occurs on the first page. So, for example a state changes from "on going" to "closed". When the state changes to "closed" all the relevant data would get copied to another sheet, then the original data is deleted. So, do you think that could be done with a Macro?

Re: Microsoft Excel 9 years 10 months ago #30494

I'm not sure if you can run it exaclty when the state changes, but you can schedules to check certain cells for certain values in the worksheet each x min.
For example, below macro will check cell B5 for a value, if that value is "closed" then it will "cut" it and paste it into cell B8 otherwise a message box shows message "Done" (you can remove message box and not doing any action).
Sub Macro1()
' Macro1 Macro

If Range("B5") = "closed" Then


Else: MsgBox "done"

End If

End Sub

Check this link for more info regarding these VB codes

always Face your Fears...

Re: Microsoft Excel 9 years 10 months ago #30495


Thanks for that, I'll have a play with that later. Oh, and by the way, what a fantastic website in the link :) thanks for that.


  • Page:
  • 1
Time to create page: 0.104 seconds


Cisco Routers

  • SSL WebVPN
  • Securing Routers
  • Policy Based Routing
  • Router on-a-Stick

VPN Security

  • Understand DMVPN
  • GRE/IPSec Configuration
  • Site-to-Site IPSec VPN
  • IPSec Modes

Cisco Help

  • VPN Client Windows 8
  • VPN Client Windows 7
  • CCP Display Problem
  • Cisco Support App.

Windows 2012

  • New Features
  • Licensing
  • Hyper-V / VDI
  • Install Hyper-V


  • File Permissions
  • Webmin
  • Groups - Users
  • Samba Setup